Are UNIQUE indices case sensitive in MySQL?

Viewed 24458

Are indices (indexes) defined as UNIQUE case sensitive in MySQL?

2 Answers

It depends on the collation of the field - if it's ci (case insensitive) or cs (case sensitive). The unique index would apply accordingly.

Related