Change collation of a MySQL table to utf8_general_cs

MySQL doesn't have case-sensitive Unicode collations, because it's a difficult problem. Some languages collate lower-case before upper-case, and others collate upper-case before lower-case. SQL Server tries to do case-sensitive Unicode, taking locale into consideration.

You have a couple of choices:

  • use collation utf8_bin (probably the easiest)
  • http://dev.mysql.com/doc/refman/5.1/en/adding-collation-unicode-uca.html