Which collation should I use when my entire application goes for UTF-8?

I'm using MySQL, latest version. By default I get la开发者_如何学编程tin1_swedish_ci which doesn't sound really correct.

You should use utf8_general_ci

Here is a full list of the character sets and their descriptions from the MySQL reference site.

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 doing it with an existing database.