BUG: SQL Error while posting
-
I've got this error while posting a topic with non-latin characters (I had to replace them to post this report):
A Database Error Occurred
Error Number: 1267Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
SELECT COUNT(*) AS count FROM exp_forum_topics WHERE body = 'The forum page doesn't show the utf8 letters in author names while the other pages do.\n\nFor example:\n\nbq. http://developer.qt.nokia.com/forums/\nLast post: Nokia Qt Ambassador Badge by Ivan ?uki? | 3 minutes ago Go to last post | RSS feed\n\nhttp://developer.qt.nokia.com/forums/viewforum/5/\n\nbq. Nokia Qt Ambassador Badge\nby: Ivan Cukic | Views: 3 | Added 4 minutes ago\n\n\n'
-
Seems related to your other issue reported here: http://developer.qt.nokia.com/forums/viewthread/471/
In general, it seems like non-latin characters are not well supported yet. I found that to be a general problem on the web, by the way.
-
Well, although those are the issues with non-latin chars - they are not really the same. One is about (not) showing correctly saved chars, while the other is about inserting non-latin chars into the db.
This really was the problem with a lot of sites before utf-8 was so widely adopted (esp with php4 and mysql) but lately I don't have problems except in mailman systems :)
:) Replace it with a pink unicorn and all will be fine (I have to promote the fluffiness, bunnies and pink unicorns as a KDE member :) )
-
About a year ago "Ariya":http://labs.trolltech.com/blogs/author/ariya/ made us a browser that would make any website pink on demand, after that episode we have tried to stick with orange. Would orange bunnies be good enough? :)
"http://www.youtube.com/watch?v=TMf7G7IU7Cg":http://www.youtube.com/watch?v=TMf7G7IU7Cg
-