[Openstack] Unique key is case-sensitive or *in*sensitive?

Nachi Ueno ueno.nachi at nttdata-agilenet.com
Tue Jan 10 21:43:51 UTC 2012


Hi Jay

Thanks
Is it possible to do it on sqlalchemy.migration ?


2012/1/10 Jay Pipes <jaypipes at gmail.com>:
> +1 for Case Sensitive. For MySQL, this is a configuration issue. The
> default character set and collation should use the *_cs variants. For
> existing MySQL installations, an ALTER TABLE ... MODIFY COLUMN ...
> CHARACTER SET ... COLLATION ... *_cs would need to be done for
> affected tables.
>
> -jay
>
> On Tue, Jan 10, 2012 at 4:15 PM, Nachi Ueno
> <ueno.nachi at nttdata-agilenet.com> wrote:
>> Hi folks
>>
>> Nova,Keystone,Glance uses RDBMS and they use unique key constraints.
>> Nowadays, we can use Mysql,Sqlite,Postgresql.
>> Unfortunately, the unique key behaviors of each DB are different.
>>
>> - Mysql : case-insensitive
>> - Sqlite : case-sensitive
>> - Postgresql : case-sensitive
>>
>> I wanna know the spec of OpenStack.
>> Unique key is case-sensitive or *in*sensitive?
>>
>> Cheers
>> Nati
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openstack
>> Post to     : openstack at lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~openstack
>> More help   : https://help.launchpad.net/ListHelp




More information about the Openstack mailing list