16.20 - Assigning the Default Client Character Set During Client Setup - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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://developer.teradata.com/connectivity/reference/jdbc-driver .

.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 http://developer.teradata.com/connectivity/reference/dotnet-data-provider.