[MediaWiki-l] utf-8

Steve VanSlyck s.vanslyck at spamcop.net
Sun Jan 27 18:06:12 UTC 2013


So this command should use --default-character-set=binary, then, and not 
--default-character-set=utf8 ?

mysqldump -h hostname -u userid -ppassword --default-character-set=binary dbname > backup.sql




On 1/27/2013 12.49, Amir E. Aharoni wrote:
> 2013/1/27 Steve VanSlyck <s.vanslyck at spamcop.net>:
>> Hi. If MediaWiki prefers utf-8. My server admint installed mediawiki and
>> didn't follow the instructions precisely so I now have
>>
>> # MySQL table options to use during installation or update
>> $wgDBTableOptions   = "ENGINE=InnoDB, DEFAULT CHARSET=binary";
> The short answer is that this is fine: This is the default and it
> allows storing UTF-8 text, and it's even supposed to offer better
> performance.
>
> If I knew MySQL properly, I'd give you the long answer, too :)
>
> People who do know MySQL are welcome to correct me if I'm wrong.
>
> --
> Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי
> http://aharoni.wordpress.com
> ‪“We're living in pieces,
> I want to live in peace.” – T. Moore‬
>
>
>> Is there an easy way to convert from binary to UTF-8?
>>
>>
>>
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l




More information about the MediaWiki-l mailing list