String Data Types

1. CHAR(l)

CHAR is a fixed length string data type. Range can be from 0 to 8000 chars. Character values are stored with the specified length(l) and they are right padded with spaces.

2. VARCHAR(l)

VARCHAR is a variable length string data type. Range can be from 0 to 8000 chars

3. BINARY and VARBINARY

BINARY and VARBINARY are very similar to CHAR and VARCHAR except that the data is stored as bytes where as the data is stored as characters for CHAR and VARCHAR. BINARY values are right padded with spaces.

4. TEXT

TEXT is variable length character string. Range can be from 0 to 2,147,483,647 chars.