System Determination of Client Character Set | Teradata Vantage - System Determination of Client Character Set - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.