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
To verify that the character set that you want to use is installed on the Teradata server:
- Log on to the Teradata server by using the BTEQ utility or any other valid logon utility.
Issue the following statement to display the dbc.chartranslations
select * from dbc.chartranslations;
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
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.
- Restart the Teradata server to update the list of character sets. In a Teradata command window, enter: tpareset -f reason_for_restart