15.10 - System Determination of Client Character Set - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

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.