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'



  • 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.



  • There is a gremlin based on latin1 somewhere in our garden, we shall train it to pass utf8 as soon as we find it.



  • @Andre

    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 :)

    @MariusG

    :) 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 :) )



  • @Ivan

    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



  • 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 :)


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.