Chinese (or Japanese) characters causing problems

A historical forum for issues reported in the suggestions and bugs forum that have been subsequently fixed or resolved.
Post Reply
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 10 (i:8)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Chinese (or Japanese) characters causing problems

Post 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
User avatar
Jools
Expert
Posts: 16277
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 941
My catfish: 237
My cats species list: 87 (i:235, k:1)
My BLogs: 7 (i:10, p:167)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: Chinese (or Japanese) characters causing problems

Post 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
Post Reply

Return to “All Resolved Issues”