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

Error inserting value in field varchar(1) with prepared query with ODBC sql driver

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Not Evaluated
    • 5.15.14, 6.5.0
    • 5.15.13
    • SQL Support
    • None
    • All
    • 5a334b3d2 (dev)

    Description

      Inserting a string made by 1 char with a prepared query fails with error

      [Microsoft][SQL Server Native Client 11.0][SQL Server] String or binary data would be truncated.

      The same software works with Qt 5.15.12

      Attachments

        1. CMakeLists.txt
          2 kB
        2. main.cpp
          1 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-113280 [REG: 5.15.8->5.15.13] ODBC driver does not work anymore

          • P1: Critical - Urgent and Important, will STOP the release if matched with set FixVersion field. This includes regressions from the last version that are not edge cases; Data loss; Build issues; All but the most unlikely crashes/lockups/hanging; Serious usability issues and embarrassing bugs & Bugs critical to a deliverable. This is the highest possible priority for requirements.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-112674 odbc sqldriver ends up with errors because the size of data is returned 1 char higher.

          • P2: Important - Urgent, should be fixed, but will not stop the release.
          • Closed
          For Gerrit Dashboard: QTBUG-112375
          # Subject Branch Project Status CR V
          469494,7 SQL/tests: Add testcase for QODBC toSQLTCHAR() dev qt/qtbase Status: MERGED +2 0
          470457,3 SQL/tests: Add testcase for QODBC toSQLTCHAR() 6.5 qt/qtbase Status: ABANDONED -1 0

          Activity

            People

              chehrlic Christian Ehrlicher
              marcolazzarotto Marco Lazzarotto
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes