ANSI-Latin1 (1252) Code Page - Access Module

Teradata Tools and Utilities Access Module Reference

Product
Access Module
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2019-03-27
dita:mapPath
amk1499705096540.ditamap
dita:ditavalPath
amk1499705096540.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities

When the ASCII character set is specified, the Teradata Access Module for OLE DB uses the code page of the system locale. If the code page of the system locale is one in which some characters consume more than one byte, the Teradata Access Module for OLE DB can return longer character fields during execution of a load job than if the 1252 code page were used. Teradata OleLoad generates load job scripts that account for this change.

Update any existing scripts. For example, a system locale of “Chinese (Taiwan)” has a code page of 950, which has a maximum character size of 2 B. If existing FastLoad job scripts using the ASCII session character set to load character data from the Teradata Access Module for OLE DB, update the scripts to account for the fact that there may be 2 B per character. For example, double the value of n in CHAR(n) and VARCHAR(n) fields located in the CREATE TABLE and DEFINE statements included in the FastLoad job scripts.