views:

795

answers:

2

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
+2  A: 

There's nothing special about UNIQUE indexes - they follow the same case options as other indexes.

le dorfier