openstack team mailing list archive

[Nachi Ueno <ueno.nachi@xxxxxxxxxxxxxxxxxxxx>]

Hi Jay

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


2012/1/10 Jay Pipes <jaypipes@xxxxxxxxx>:
> +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@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openstack
>> More help   : https://help.launchpad.net/ListHelp