Data Types
Character types
Data type | Alias | Description |
---|---|---|
CHAR(n) | CHARACTER(n) | Fixed size character string of size n. See Database Limitations. |
VARCHAR[(n)] | CHARACTER VARYING [(n)] , TEXT | variable-length with optional limit (n). If n isn’t specified, the maximum is used. See Database Limitations. |
Notes
-
Only ASCII characters are supported, 1 char = 1 byte.
-
Character type literals should be surrounded by single quotes. Those must be the basic ASCII character 39 (’). Other variants, such as the left single-quote and right single-quote ASCII characters 145-146 (‘like this’), are not supported and would result in an error.