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

QODBC-DB2 Unicode support is not recognised

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Reported
    • Priority: P2: Important
    • Resolution: Unresolved
    • Affects Version/s: 5.15.6
    • Fix Version/s: None
    • Component/s: SQL Support
    • Labels:
      None
    • Environment:
      ODBC with IBM i Access ODBC Driver - Windows
    • Platform/s:
      All

      Description

      In the QODBCDriverPrivate::checkUnicode() method, the query QLatin1String("select 'test'")) attempts to determine whether the database supports Unicode. 
      SELECT without FROM is not standard-compliant. DB2 and Oracle do not allow a query without FROM.

      Possible solution:
      At least DB2 supports the values('test') statement.
      Possible solution (but not the nicest):
      r = SQLExecDirect(hStmt, toSQLTCHAR(QLatin1String("select 'test'")).data(), SQL_NTS); if(r != SQL_SUCCESS) r = SQLExecDirect(hStmt, toSQLTCHAR(QLatin1String("values('test')").data(), SQL_NTS);

       

        Attachments

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

          Activity

            People

            Assignee:
            mabrand Mark Brand
            Reporter:
            sebastianst Sebastian Stadelmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Gerrit Reviews

                There are no open Gerrit changes