Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-59176

[REG: 5.7->5.8] Multibyte unicode characters are not working with MySQL

    XMLWordPrintable

Details

    • e7f019011ace53d83d439c7c596fb063e02f5d79

    Description

      Now Qt enables utf8mb4 for proper utf8 support in MySQL if it supports it. Unfortunately rest of the plugin code still assumes MySQL does not support utf-8 and translates every query with system codec. When trying to run:

          query.exec("INSERT INTO table (description) VALUES ('æøå')");
      

      It throws out:

      "Incorrect string value: '\\xE6\\xF8\\xE5' for column 'description' at row 1 QMYSQL: Unable to execute query"
      

      These characters appear to be in latin1 encoding.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            poikelin Joni Poikelin
            poikelin Joni Poikelin
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes