15.10 - CharSetsV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

CharSetName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Translation.TranslateName (UPI)

The Teradata Database can support many user‑defined character sets (see “CharTranslationsV” on page 80). You can install a maximum of 12 character sets at any given time. The CharSets view contains the names of character sets that are currently installed and can be specified at the session level. If the view does not exist or no rows are found, then no user‑defined character sets are available.

CharSetName

Each name shown in CharSets can be used as the identifier in the BTEQ [.]SET SESSION CHARSET <'name'> command or the CLIv2 call CHARSET <name>. However, the specified character set should be compatible with the internal code of the logon client system.

If a CharSetName is ambiguous as to its compatibility with the logon client system of the viewer session, consult the Teradata Database administrator.

The following example shows that two user‑defined character sets are available for the requesting user:

==> SELECT * FROM DBC.CharSetsV;

Result:

CharSetName
French_EBCDIC
Swedish_EBCDIC