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