Page 1 of 1

Chinese (or Japanese) characters causing problems

Posted: 28 Nov 2008, 11:11
by MatsP
The latest post (at this point in time) in this thread http://www.planetcatfish.com/forum/view ... =4&t=20862
causes:
General Error
SQL ERROR [ mysql4 ]

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
when trying to view that post

--
Mats

Re: Chinese (or Japanese) characters causing problems

Posted: 29 Nov 2008, 09:24
by Jools
Yes, fixed now and also in other areas where this would casue problems. For those interested, the forum uses utf8_bin encoding and the rest of the site uses latin1_swedish_ci, so when you get characters outside of the western european set, stuff breaks. I've fiddled that out now so it should work as only the forum username field is the issue (for now) unless folks start, for example, writing my cats notes in Chinese.

Jools