SHOW TABLE and Language Support Mode of a System - Advanced SQL Engine - Teradata Database

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';