16.10 - Assigning the Default Client Character Set During Client Setup - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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.

See Teradata Call-Level Interface Version 2 Reference for Network-Attached Systems.

On mainframe clients:

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

See Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems.

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

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.

See Teradata JDBC Driver User Guide.

Windows .NET Specify the default character set in the connection dialog box of the client tool. For an example, see Teradata SQL Assistant for Microsoft Windows User Guide on how to define a .NET data provider.