AttentionThis page is from an older version. Click here to go the latest version.
Character types are used to specify data of a string of Unicode characters.
type_specification ::= TEXT | VARCHAR text_literal ::= "'" [ '' | letter ...] "'"
- Single quote must be escaped as (“).
letteris any character except for single quote (
- Columns of type
VARCHARcan be part of the
- The length of
TEXTstring is virtually unlimited.
- Currently, value of type character datatype are neither convertible nor comparable to non-text datatypes. This restriction will be removed.