Enabling a Client Character Set

Teradata Database International Character Set Support

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

1 Set the InstallFlag column to Y for all character sets you want to activate. The limit is 16 active character sets.

UPDATE DBC.CharTranslationsV SET InstallFlag=’Y’ WHERE CharSetId = charactersetid;

or

UPDATE DBC.CharTranslationsV SET InstallFlag=’Y’ WHERE CharSetName = ‘charactersetname’;

2 Perform a full restart of Teradata Database, using the tpareset utility.

Note: If more than 16 rows are flagged as Y at tpareset, the system sorts CharSetName values in ascending ASCII sequence and enables the rows in alphabetical order until the 16 set limit is reached.

For usage information, see tpareset in Utilities.