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";
Is there an easy way to convert from binary to UTF-8?
2013/1/27 Steve VanSlyck s.vanslyck@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 27/01/13 19:06, Steve VanSlyck wrote:
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
Probably. Although it's possible that it is only used if your table doesn't have an explicit charset (which it likely has).
About the long answer: mysql utf-8 support is limited to the BMP, using binary, allows the full set. It is also better for indexing as it doesn't use so bytes much per character (assuming a mostly-latin text).
mediawiki-l@lists.wikimedia.org