Change collation of a MySQL table to utf8_general_cs
- by jack
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?