System Determination of Client Character Set - Teradata Database

You can specify the client character set in several ways. The system determines the client character set for a session according to the following order of precedence. Each higher numbered item, if it exists, supersedes the previous item.

1 If no default client character set is specified, the system automatically defaults to:

EBCDIC for mainframe clients

ASCII for all other clients

2 You can specify the default character set for client host groups, by HostID, in the DBC.HostsInfoV view. See “Assigning the Default Client Character Set by HostId” on page 57.

3 You can specify the default character set on the client computer when setting up application connections to the database, for example, when setting up the:

Teradata Call-Level Interface (CLIv2) for applications such as BTEQ

ODBC driver for applications such as Teradata Administrator and SQL Assistant

JDBC Driver

Windows .Net environment

See “Assigning the Default Client Character Set During Client Setup” on page 56.

4 Users can specify the character set for a session using application settings, which override any defaults set by other methods. See “Assigning the Default Client Character Set for a Session” on page 59.