v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

Character data types

Synopsis

Character-based data types are used to specify data of a string of Unicode characters.

Data type Description
CHAR Character string of 1 byte
CHAR (n) Character string of fixed-length (n) and blank padded
CHARACTER (n) Character string of fixed-length (n) and blank padded
CHARACTER VARYING (n) Character string of variable-length with maximum limit (n)
VARCHAR (n) Character string of variable-length with maximum limit (n)
VARCHAR Character string of variable and unlimited length
TEXT Character string of variable and unlimited length

Description

text_literal ::= "'" [ '' | letter ...] "'"

Where

  • Single quote must be escaped as ('').
  • letter is any character except for single quote ([^']).
  • Character-based data types can be part of the PRIMARY KEY.
  • Value of character data type are convertible and comparable to non-text data types.