Good Afternoon MediaWiki Fans:
I'm migrating our installations to a new machine with upgraded
everything. I'm wondering of the MySQL character set choices
are important.
My older installation is: MySQL 5.0.22-standard
and the new one is: 5.5.11
The older MySQL installation reports character sets:
$ mysqlCmd -e "show variables;" mysql | egrep -i
"character|collation"
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
The new MySQL system reports:
$ mysqlCmd -e "show variables;" mysql | egrep -i
"character|collation"
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
character_sets_dir /usr/share/mysql/charsets/
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
Is anything in the system going to care that some latin1 types are now utf8 ?
--Hiram