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

_______________________________________________
MediaWiki-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply via email to