What sorting should I use when my application extends to UTF-8?

Question

I am using MySQL, the latest version. By default, I get latin1_swedish_ci, which doesn’t sound quite right.

Answer 1

You have to use utf8_general_ci

Here is a complete list of character sets and their description from the MySQL link site.

Answer 2

You can change the default collation from the MySQL database configuration files.

Also see this link http://streetsmartingit.blogspot.com/2008/04/how-to-changeconvert-your-mysql.html for instructions on how to use it with an existing database.