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