Server Data Type is Always Set to Unicode - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
Product Category
Teradata Tools and Utilities

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.