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

ODBC Oracle wrong detection for unicode

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: P2: Important P2: Important
    • 6.5.1, 6.6.0
    • 5.14, 5.15, 6.x
    • SQL Support
    • None
    • Windows
    • f19320748 (dev), b8f140b70 (6.5)

      The follwoing select statement executed wiith QSqlQuery:

      "SELECT 'ÄÖÜäöüß§' FROM dual"

      returns thge result:

      ???????

      After some debugging in the Qt source, it seems, unicode mode in the Qt SQL ODBC driver plugin isn't detected right. In QODBCDriverPrivate::checkUnicode() the member variable 'unicode' isn't set to true. If I set this variable with the debuger to true the query returns the right result: 'ÄÖÜäöüß§'

       

      My ODBC connection string:

      DSN=TEST;DBQ=XE ;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=T;FBS=64000;TLO=O;MLD=0;ODA=F;TSZ=8192;

       

      I trie FWC (force wide character) with true or fals but this changes nothing.

       

      The orcale settings:

      NLS_LANGUAGE GERMAN
      NLS_TERRITORY GERMANY
      NLS_CURRENCY €
      NLS_ISO_CURRENCY GERMANY
      NLS_NUMERIC_CHARACTERS ,.
      NLS_CALENDAR GREGORIAN
      NLS_DATE_FORMAT DD.MM.RR
      NLS_DATE_LANGUAGE GERMAN
      NLS_CHARACTERSET WE8MSWIN1252
      NLS_SORT GERMAN
      NLS_TIME_FORMAT HH24:MI:SSXFF
      NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
      NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
      NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
      NLS_DUAL_CURRENCY €
      NLS_NCHAR_CHARACTERSET AL16UTF16
      NLS_COMP BINARY
      NLS_LENGTH_SEMANTICS BYTE
      NLS_NCHAR_CONV_EXCP FALSE

       

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

            mabrand Mark Brand
            blgis Bernd Lachner
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes