Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5687

Oracle comparison with binding of nchar with non-ascii chars is not correct

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 12.2
    • None
    • JDBC Connector
    • None

      An nchar column binding in the where clause will use the FIXED_CHAR (999) oracle type - however that converts the value to ascii, which may result in invalid results:

      nchar_col = ?

      where ? is bound to Ā would search instead for A.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: