Support for Unicode® and UTF-8 - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

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, or if you are working with Teradata Database V2R5.0 or lower, all fixed length character data can 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.

The following sections contain related information.

  • Displaying Unicode® Data
  • Exporting Unicode® Data
  • Importing Unicode® Data