Change Database Character encoding
Posted: Sun Oct 23, 2011 10:25 am
I'm trying to move a database into UTF8 and I thought about just changing the latin1's to utf8, but it seems there are several settings:
[text]Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8[/text]
Also there are several collations as latin1_swedish_ci
Is there a preferred procedure for converting a database character set to all utf8? There seems to be a vary wide range of methods on the internet.
Thanks!
[text]Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8[/text]
Also there are several collations as latin1_swedish_ci
Is there a preferred procedure for converting a database character set to all utf8? There seems to be a vary wide range of methods on the internet.
Thanks!