case-sensitive queries in MySQL

Question

I have a table with a column named "Shortcut". I want these IDs to be case-sensitive (so say shortcut myshortcut is different from Myshortcut).

Right now, when I select a row with the shortcut, it is not case sensitive. So in my example above, both shortcuts refer to the same field.

What can I do?

Thanks

Answer 1

You can use one of the binary types (varbinary) instead of the text (varchar) types. Alternatively, change the collation on the text column to binary (column_name varchar(16) binary). See the documentation on binary collations.