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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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