16.10 - Enabling a Client Character Set - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K
  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.
    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.