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 mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
