CHARACTER (CHAR)

The CHARACTER type is a fixed-length, blank padded string.

Syntax

[ CHARACTER | CHAR ] (n)

Semantics

n	specifies the length of the string. The default length is one (1). The maximum length is 4000.

Notes

On input, strings are truncated if necessary to the specified number of characters.
Remember to include the extra bytes required for multibyte characters in the column width declaration.
String literals in SQL statements must be enclosed in single quotes.
Vertica does not support the PostgreSQL TEXT type. Use VARCHAR instead.
Due to Vertica's use of compression, the cost of over-estimating the length of
these fields is incurred mostly at load time and during sorts.
CHAR fields are padded on the right with spaces as needed.
No embedded NULs are allowed.
In CHAR fields NUL characters are handled as ordinary characters.
NULL appears last (largest) in ascending order.