Server Data Type is Always Set to Unicode - Access Module

Teradata Tools and Utilities Access Modules User Guide

Access Module
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Server Data Type is Always Set to Unicode

Problem: The server data type of a character string is always set to Unicode even if KANJSIJIS_OS is specified as the session character set.

Solution: When creating load scripts, the Teradata OLE DB Access Module assigns a character data type for a destination table based on the session character set that is specified. If ASCII or LATIN1252_0A is specified, then a LATIN character data type is assigned; otherwise, a Unicode character data type is assigned. Scripts can be modified to use any supported character data type.