Are UNIQUE indices case sensitive in MySQL?

mysql indexing key unique case-sensitive
nickf picture nickf · Jan 21, 2009 · Viewed 19.5k times · Source

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

Answer

Eran Galperin picture Eran Galperin · Jan 21, 2009

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 questions

Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?

What are the differences between PRIMARY, UNIQUE, INDEX and FULLTEXT when creating MySQL tables? How would I use them?

Read More
What's the difference between using INDEX vs KEY in MySQL?

I know how to use INDEX as in the following code. And I know how to use foreign key and primary key. CREATE TABLE tasks ( task_id INT UNSIGNED NOT NULL AUTO_INCREMENT, parent_id INT UNSIGNED NOT NULL DEFAULT 0, …

Read More
Is the primary key automatically indexed in MySQL?

Do you need to explicitly create an index, or is it implicit when defining the primary key? Is the answer the same for MyISAM and InnoDB?

Read More