[Answered] Why Mysql Charset Is Latin1

[Guest pyfxl]

Hi superadmin,

I from china, I use utf8 charset to my mysql database, but, the hosting the charset is latin1, so I get error message form my website.

Can you support utf8 charset.

[Shinryuu]

Utf8 is supported, latin1 is just the default, we could probably change the default charset to utf8 without breaking anything though. There's a drop-down for setting charsets in fields that are characters/strings and the one you want to choose is utf8_general_ci for utf8.

[Guest pyfxl]

I selected utf8_general_ci , but still can't display Chinese . I hope could change the default charset to utf 8 , then support any Language .

[Krydos]

There are 126 collations in MySQL, only 10 of which are suited for simplified Chinese.

http://www.haidongji.com/2007/10/04/character-set-and-collation-for-simplified-chinese-mysql/

 

utf_general_ci is not one of them.

 

I would recommend trying utf8_unicode_ci or big5_chinese_ci both of which are available on Heliohost.