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

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K

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 Access Module for OLE DB 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.