Enabling a Client Character Set | Teradata Vantage - Enabling a Client Character Set - Advanced SQL Engine - Teradata Database

International Character Set Support
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantage™
  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.