Are indices (indexes) defined as UNIQUE case sensitive in MySQL?
+6
A:
It depends on the collation of the field - if it's ci (case insensitive) or cs (case sensitive). The unique index would apply accordingly.
Eran Galperin
2009-01-21 01:13:04
+2
A:
There's nothing special about UNIQUE indexes - they follow the same case options as other indexes.
le dorfier
2009-01-21 01:15:51