15.10 - Server Data Type is Always Set to Unicode - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

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.