Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
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: 1267
Illegal 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'
andre last edited by
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.
mgran last edited by
There is a gremlin based on latin1 somewhere in our garden, we shall train it to pass utf8 as soon as we find it.
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 :) )
mgran last edited by
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? :)
Heh, I remember that one :) I'm afraid to remind the Fluffy team of that... I wouldn't be surprised if they turned somthing like that in kdewebkit on by default :)
As for orange bunnies, you'll have to ask KDE Multimedia team on their next dev sprint :)