Error Handling - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities
Not all characters can be converted between Unicode and other non-Unicode code pages. Therefore, some characters are converted into error characters. See "Error Characters" in Teradata® Database International Character Set Support (B035-1125). In most cases, conversion errors result in the following Teradata Database errors:
  • 6706 – The string contains an untranslatable character
  • 6705 – An illegally formed character string was encountered during translation

In some cases, the “?” is used as the error character. In these cases, Teradata Database cannot detect conversion errors. Therefore, SQL-Text and character strings should match the session character set repertoire to avoid conversion errors.