On Sun, Nov 22, 2009 at 17:57, Anthony wikimail@inbox.org wrote:
Hmm, okay. Should I be using character set and collation "binary"?
Yes. The main problem with using UTF-8 for the tables is that MySQL only supports Unicode characters U+0000 .. U+FFFF. Other characters are silently removed, which leads to problems with duplicate page titles etc.
See http://dev.mysql.com/doc/refman/5.1/en/charset-unicode.html