[Openstack] Unique key is case-sensitive or *in*sensitive?
Jay Pipes
jaypipes at gmail.com
Tue Jan 10 21:31:27 UTC 2012
+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