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

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

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 Workstation-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.