Accessing Client Character Set Information - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database
 

IF you want to…

THEN…

display the client character set currently in effect for your session

use the HELP SESSION statement.

review the contents of the system tables associated with language support

query the DBC.HostsInfoV, DBC.CharSetsV, or DBC.CharTranslationsV views.

The presence of a character set in DBC.CharSetsV or DBC.CharTranslationsV does not mean it is active. The InstallFlag column in DBC.CharSetsV or DBC.CharTranslationsV is a good indication, but can be misleading if the table has been changed without performing a restart of the Teradata Database.

ASCII, EBCDIC, UTF16, and UTF8 character sets, which are predefined and permanently loaded into the system, are always available. The character sets are not listed in DBC.CharTranslationsV.