[Mediawiki-l] MySQL character set choice

Fred Bauder fredbaud at fairpoint.net
Thu May 12 00:34:58 UTC 2011


> Hiram Clawson wrote:
>> 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
> (...)
>> Is anything in the system going to care that some latin1 types are now
>> utf8 ?
>>
>> --Hiram
>
> No. You can set the collation per table, and MediaWiki can use latin1,
> binary or utf8 (it needs to be configured correctly).
> You only need to be careful with not corrupting the dump. You may need
> to set --default-character-set
> See http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Character_set

An error results in this kind of stuff:

[[es:Br�coli]][[pt:Br�colis]]

Fred




More information about the MediaWiki-l mailing list