CHARACTER VARYING (VARCHAR)

The CHARACTER VARYING type is a variable-length string.

Syntax

[ CHARACTER VARYING | VARCHAR ] (n)

Semantics

n	specifies the maximum length of the string. The default length is 80. 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.
VARCHAR values terminate at their first NUL byte if any.
A VARCHAR(n) field is processed internally as a NUL-padded string of maximum length n.
No embedded NULs are allowed.
NULL appears last (largest) in ascending order.