Data typeAliasDescription
CHAR(n)CHARACTER(n)Fixed size character string of size n. See Database Limitations.
VARCHAR[(n)]CHARACTER VARYING [(n)], TEXTvariable-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.