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.