15.00 - Data Type, Column Storage, and Constraint Attributes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

Data Type, Column Storage, and Constraint Attributes

Column storage attributes are a Teradata extension to ANSI SQL. If you do not specify explicit formatting, a column assumes the default format for the data type, which can be specified by a custom data formatting specification (SDF) defined by the tdlocaledef utility (see Utilities: Volume 2 (L-Z)). Explicit formatting applies both to the parsing and to the retrieval of character strings.

If you change the tdlocaledef.txt file and issue a tpareset command, the new format string settings affect only those tables that are created after the reset. Existing table columns continue to use the existing format string in DBC.TVFields unless you submit an ALTER TABLE request to change it (see “ALTER TABLE (Basic Table Parameters)” on page 31).

Not all data type attributes are supported for UDT, ARRAY, VARRAY, Geospatial, and Period column declarations, and no column storage or column constraint attributes are supported for those types.

You can specify server character sets for character data by specifying CHARACTER SET server_character_set for character columns.

Teradata Database supports the following server character sets.

  • LATIN
  • UNICODE
  • KANJISJIS
  • GRAPHIC
  • You cannot specify the server character set KANJI1. Otherwise, Teradata Database aborts the request and returns an error to the requestor

    Teradata Database automatically converts any existing character columns with a server character set of Kanji1 to a server character set of Unicode.