Enabling a Client Character Set - 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

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.