Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Behind the Scenes
  3. Qt.io webservices
  4. BUG: SQL Error while posting
Forum Updated to NodeBB v4.3 + New Features

BUG: SQL Error while posting

Scheduled Pinned Locked Moved Qt.io webservices
6 Posts 3 Posters 3.7k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    ivan
    wrote on last edited by
    #1

    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'

    Ivan Čukić | ivan.cukic(at)kde.org | KDE e.V.
    Qt Ambassador (from the old Nokia days)

    1 Reply Last reply
    0
    • A Offline
      A Offline
      andre
      wrote on last edited by
      #2

      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.

      1 Reply Last reply
      0
      • M Offline
        M Offline
        mgran
        wrote on last edited by
        #3

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

        Project Manager - Qt Development Frameworks

        1 Reply Last reply
        0
        • I Offline
          I Offline
          ivan
          wrote on last edited by
          #4

          @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 Čukić | ivan.cukic(at)kde.org | KDE e.V.
          Qt Ambassador (from the old Nokia days)

          1 Reply Last reply
          0
          • M Offline
            M Offline
            mgran
            wrote on last edited by
            #5

            @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

            Project Manager - Qt Development Frameworks

            1 Reply Last reply
            0
            • I Offline
              I Offline
              ivan
              wrote on last edited by
              #6

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

              Ivan Čukić | ivan.cukic(at)kde.org | KDE e.V.
              Qt Ambassador (from the old Nokia days)

              1 Reply Last reply
              0

              • Login

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Users
              • Groups
              • Search
              • Get Qt Extensions
              • Unsolved