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.