16.10 - System Determination of Client Character Set - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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.
  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 SQL Assistant
    • JDBC Driver
    • Windows .Net environment

    See Assigning the Default Client Character Set During Client Setup.

  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.