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

Lake - Database Reference
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549
Connection Type How the System 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 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.