[Mediawiki-l] Error in numRows(): Illegal mix of collations
brion at pobox.com
Sat Feb 4 18:23:08 UTC 2006
> When I try to create a Chinese or Japanese page I get this error:
> Error in numRows(): Illegal mix of collations (utf8_bin,IMPLICIT) and
> (latin1_swedish_ci,COERCIBLE) for operation '='
Did you change the character set configuration of MySQL or the tables? Don't do
that. MediaWiki uses UTF-8, but doesn't pay much attention to what MySQL thinks
the charset is; under the old "latin-1" default it'll run good clean binary
UTF-8 on top of that with few problems. Under the experimental MySQL 5 mode it
can use tables which are set up as UTF-8. Don't try to mix these modes.
-- brion vibber (brion @ pobox.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 249 bytes
Desc: OpenPGP digital signature
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20060204/f1951a88/attachment.pgp
More information about the MediaWiki-l