CHARACTER Data Type | Data Types and Literals | Teradata Vantage - CHARACTER Data Type - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantage™

Represents a fixed length character string for Vantage internal character storage.

ANSI Compliance

CHARACTER is ANSI SQL:2011 compliant.

GRAPHIC is a Teradata extension to the ANSI SQL:2011 standard.

Syntax

{ { CHARACTER | CHAR } [ ( n ) ]
    [ { CHARACTER | CHAR } SET server_character_set ] |

    GRAPHIC [ ( n ) ]

} [ attributes [...] ]

Syntax Elements

n
The number of characters or bytes allotted to the column defined with this server character set:
  • For the LATIN server character set, the maximum value for n is 64000 characters.
  • For the UNICODE and GRAPHIC server character sets, the maximum value for n is 32000 characters.
  • For the KANJISJIS server character set, the maximum value for n is 32000 bytes.

If a value for n is not specified, the default is 1.

server_character_set
The server character set for the character column being defined. See CHARACTER SET Phrase.

If the CHARACTER SET server_character_set clause is omitted, the default server character set depends on how the user is defined in the DEFAULT CHARACTER SET clause of the CREATE USER statement. See Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

In accordance with Teradata internationalization plans, KANJI1 support is deprecated and is to be discontinued in the near future. KANJI1 is not allowed as a default character set; the system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible.
Supported values for server_character_set are as follows:
attributes
Appropriate data type, column storage, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.