16.20 - SHOW TABLE and Language Support Mode of a System - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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