15.00 - SHOW TABLE and Language Support Mode of a System - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

SHOW TABLE and Language Support Mode of a System

You cannot submit a SHOW TABLE request against a dictionary table to determine the language support mode for your system because Teradata Database always returns the value Unicode as the response to such a request.

Instead, you must submit the following SELECT request to determine the language support mode used by your system.

     SELECT infodata
     FROM DBC.dbcinfoV
     WHERE infokey='language support mode';
 

IF your system uses this language support mode …

THEN the InfoKey value the system returns is …

standard

Standard

Japanese

Japanese