System Determination of Client Character Set | VantageCloud Lake - System Determination of Client Character Set - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Connection Type How the ystem determines the Session Character Set
CLIv2 You can specify the client character set in multiple ways. The system determines the client character set for a session according to the following order of precedence. Each higher numbered item, if any, supersedes the previous item.

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

  1. The default character set is defined by VantageCloud Lake for the Logical Host.
  2. The default may be overridden for a use of CLIv2 by specifying a default in the CLIv2 HSHSPB file provided for that purpose.
  3. Applications may override these defaults by explicitly specifying the character set for a specific 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.

    For gateway connections from z/OS, the system defaults to EBCDIC.

  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.