mysql indexing key unique case-sensitive

Are UNIQUE indices case sensitive in MySQL?

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

Solution

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

How do I set the default schema for a user in MySQL?
How to output geoJSON file from mysql spatial table?
PHPMyAdmin Configuration not working because of MySQL user password?
The best way of storing many to many hierarchical data in sql
JDBC connection without database definition
Can Magento Connect to Another MySQL database?
PHP isset() with multiple parameters
bootstrap table doesnot display data
CakePHP-2.0: Refactor my code editing faster sql query, need a faster sql query
ERROR 2006 (HY000): MySQL server has gone away
Problems selecting multiple column
Order rows based on another table?
MySQL Workbench edit data
brew start and brew restart wont start service
Sort MySQL query result by calculated average DESC
PHP MYSQL Array and sort
Use queryset result as a parameter to a raw SQL in Django
Getting multiple values for a date for Google Charts
is there any way to check with cumulative way to get month based on the amount fields
How to compare using bcrypt in a db query using node.js and express
SQL query to check if a name begins and ends with a vowel
MySQL JSON_OBJECT() datetime format
Why is MySQL Sorting by mp.id in This Query Execution Plan?
PHPExcel download not working properly
MySqlCommand().ExecuteReader().GetString() does not work
how to sum rows together but also leave the original rows in the results?
Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
SQL filter for same values in different columns
ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it