16.20 - Support for Unicode® and UTF-8 - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

The Teradata data source must be defined to use either a UTF-8 or UTF-16 session character set in order to successfully submit or retrieve Unicode data.

CLOBs can not be retrieved over a UTF-8 ODBC connection. CLOBs can be retrieved over a UTF-16 ODBC session if the ODBC option Use native LOB support is selected.

If this option is not selected, all fixed length character data may be returned with additional blank padding up to a length of double the actual column size. This limitation is caused by insufficient descriptive information returned to the driver from older Teradata Database releases.