Error Handling - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-18
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
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. For more information on error characters, see "Character Conversion" in International Character Set Support, B035-1125. In most cases, conversion errors result in the following database errors:
  • 6706 – The string contains an untranslatable character
  • 6705 – An illegally formed character string was encountered during translation

When the “?” is used as the error character, the database cannot detect conversion errors. Therefore, SQL-Text and character strings should match the session character set repertoire to avoid conversion errors.