Encoding and MySQL collation

Get help on installation, manual queries, database setup, and import/export of data

Encoding and MySQL collation

by stylight » Wed Jan 13, 2010 4:26 pm

Hi,

I noticed that although I set Admin > System Setting > Encoding to UTF-8, the Collation used in the database is latin1_swedish_ci rather than UTF-8 based.
Any specific reason to this choice?

Tx,
Sty
stylight  

Re: Encoding and MySQL collation

by admin » Wed Jan 20, 2010 11:04 am

That setting is only for display in web pages. It does not affect the character encoding used in the database. You are welcome to change your database table character encodings to utf-8 if you want.
admin Site Admin  

Re: Encoding and MySQL collation

by stylight » Wed Jan 20, 2010 7:26 pm

Thanks for the reply.
Sty
stylight  


Return to MySQL Support