So... I'm guessing that the solution to some other encoding problems I'm seeing is to change all the tables on all my wikis from whatever default collation was used when the dbs were created to binary? I'm guessing that may be interesting...
Sometimes I think I should have stayed with mySQL4...
Jim
On Apr 15, 2008, at 4:32 PM, Brion Vibber wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Mark Ferguson wrote:
The character set on the table is UTF8, and I reran the command using the option --default-character-set=utf8 to be sure, but I'm still getting the same problem.
This might be due to 4-byte characters, which MySQL's UTF-8 mode doesn't support properly.
Try setting up the tables with the binary schema, which may help...
- -- brion
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkgFHu8ACgkQwRnhpk1wk45MwACdGapdCmeHj1DlksmhTjc8fbaU c8sAni7rnVecT6ZgFlG8oGcdbiubTngn =EpEL -----END PGP SIGNATURE-----
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054