Enabling a Client Character Set | Teradata Vantage - Enabling a Client Character Set - Teradata Vantage - Database Engine 20

International Character Set Support
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-08-28
dita:mapPath
jun1747160330269.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
hqj1472245413611
lifecycle
latest
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 the 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 Database Utilities, B035-1102.