Assigning Default Client Character Set During Client Setup | Teradata Vantage - 17.10 - Assigning the Default Client Character Set During Client Setup - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

You can specify the default character set when setting up client connections to the database.

Connection Type Method of Specifying Default
CLIv2 Connections On network-attached clients:

Specify the character set in the clipsb.bat, using the character set ID shown in the DBC.CharTranslationsV view.

For more information, see Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418.

On mainframe clients:

Specify the character set in the System Parameter Block (HSHSPB) on the client (parameters IBCCSN, IBOSCS and IBCCSC).

For more information, see Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems, B035-2417.

ODBC Driver Connections Use the Session Character Set parameter of the Teradata ODBC driver setup dialog box to set the default client character set.

For more information, see ODBC Driver for Teradata® User Guide.

JDBC Driver Connections Specify the default character set in the CHARSET connection parameter for the Teradata JDBC driver.

For more information, see Teradata JDBC Driver Reference, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html.

.NET Data Provider for Teradata Use the Session Character Set connection-string attribute to set the client character set. See .NET Data Provider for Teradata Developer's Guide, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/tdnetdp/16.20/help/webframe.html.