CODEWITHSUNDEEP
mysqlcollation
openfrog
openfrog

Reputation: 40735

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

I'm using MySQL, latest version. By default I get latin1_swedish_ci which doesn't sound really correct.

Upvotes: 3

Views: 178

Answers (2)

Doug Neiner
Doug Neiner

Reputation: 66191

You should use utf8_general_ci

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

Upvotes: 4

PfhorSlayer
PfhorSlayer

Reputation: 1366

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.

Upvotes: 2

Related Questions