16.20 - System Determination of Client Character Set - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K
Connection Type How the system determines the Session Character Set
CLIv2 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.

For Mainframe connections (TDP) the following determines the default character set:

  1. The default character set is defined by the Teradata Database for the Logical Host.
  2. The default may be overridden for a particular use of CLIv2 by specifying it in the CLIv2 HSHSPB file provided for that purpose.
  3. Applications may override these defaults by explicitly specifying the character set for a particular use.

For Gateway connections the following determines the default character set:

  1. If no default client character set is specified, the system defaults to ASCII for gateway connections.
  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. Users can specify the default character set on the client computer when setting up application connections to the database. See Assigning the Default Client Character Set During Client Setup.
  4. You 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.
Teradata JDBC Driver The Teradata JDBC Driver determines the session character set solely by the CHARSET connection parameter. If the CHARSET connection parameter is omitted, the Teradata JDBC Driver uses the ASCII session character set. See Assigning the Default Client Character Set for a Session.
ODBC Driver for Teradata An application or a user can specify the session character set option in the connection string for the connection. See Assigning the Default Client Character Set During Client Setup.
.NET Data Provider for Teradata An application or a user can specify the session character set option in the connection string for the connection. The .NET Data Provider defaults the session character set to ASCII when an application or user does not specify a session character set connection string option. See Assigning the Default Client Character Set During Client Setup.