Verifying the character set on the Teradata server

If the correct character set is not specified on the Teradata server, you can receive connection errors. Verify that the character set that you want to use is installed on the Teradata server.

About this task

Procedure

To verify that the character set that you want to use is installed on the Teradata server:

Procedure

  1. Log on to the Teradata server by using the BTEQ utility or any other valid logon utility.
  2. Issue the following statement to display the dbc.chartranslations table: select * from dbc.chartranslations;
  3. Check the value in the third column, InstallFlag, of the table that is returned. The value ’Y’ in the third column indicates that the character set is installed and in use on the Teradata server.
    Use the following table to determine if you have the correct character set installed:
    Table 1. Character sets for Teradata
    Double-byte character set Single-byte character set Teradata character set Language IBM Db2® code set
    941 897 "KanjiSJIS_0S" Japanese IBM-943
    1362 1126 "HANGULKSC5601_2R4" Korean 1363
    1385 1114 "SCHGB2312_1T0" Simplified Chinese GBk
    380 1115 "SCHGB2312_1T0" Simplified Chinese IBM-1381
    947 1114 "TCHBIG5_1R0" Traditional Chinese big5
    1200 1208 "UTF8" Unicode UTF-8
    0 819 "Latin1_0A" English (Latin 1) ISO8859-1
    0 1252 "Latin1252_0A" English (Win Latin) ISO8859-1/15
    0 819 "ASCII" English (ASCII) ISO8859-1
  4. If you do not have the required character set installed, install the character set to use the Teradata wrapper.
    • ASCII is enabled on the Teradata server, but it is not cataloged in the dbc.chartranslations table. If all of the values that are returned for InstallFlag are 'N', ASCII is the only valid character set on the Teradata server and the TERADATA_CHARSET environment variable must be set to ASCII in the db2dj.ini file.
    • If the character set that you want to use is listed in the dbc.chartranslations table, but the InstallFlag value is set to ’N’, issue the following statement to change the InstallFlag to ’Y’: 
      update dbc.chartranslations 
     set installflag=’Y’ where CharSetName= ’character_set_name’;
    • If the character set that you want to use is not listed in the dbc.chartranslations table, contact Teradata customer support.
  5. Restart the Teradata server to update the list of character sets. In a Teradata command window, enter: tpareset -f reason_for_restart