VARCHAR

The VARCHAR data type is a variable-length character string. For example, a column declared as VARCHAR(25) holds up to 25 bytes in each row, depending on the length of the strings that are loaded. For details and examples, see Trailing Blanks in Character Data.

Note that VARCHAR columns can hold a given number of bytes, not characters.

An attempt to load a string that is longer than the specified length of a VARCHAR column results in a value too long error.

The maximum length of a VARCHAR column is 64000 bytes. The maximum length of a row in a table is 64256 bytes.

If you create a VARCHAR column without specifying a length, the default length is 256 bytes.