16.20 - Enabling a Client Character Set - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K
  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 Teradata Vantage™ - Database Utilities , B035-1102 .