System Determination of Client Character Set | Teradata Vantage - System Determination of Client Character Set - Analytics Database - Teradata Vantage

International Character Set Support
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
lifecycle
latest
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 Vantage 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.