Home / server / Questions / 137415
Accepted
jack
Asked: 2010-05-01 06:20:15 +0800 CST

Change collation of a MySQL table to utf8_general_cs

  • 772

I tried to change collation MySQL table to utf8_general_cs but got following error:

mysql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_cs';
ERROR 1273 (HY000): Unknown collation: 'utf8_general_cs'

I run "SHOW COLLATE" command and "utf8_general_cs" is not in the results.

What can I do now?

mysql sql

1 Answers

  1. Best Answer

    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:

    • 13