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

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

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.