VARCHAR(size)
The VARCHAR
data type is a variable length data type that can contain any character
you can enter from the keyboard. The minimum length of VARCHAR columns
is 1 character, and the maximum length is 3992 characters. You must enter
a value for the size parameter when creating a VARCHAR column.
Unlike the
CHAR data type which uses spaces for padding, only the characters entered
are stored in the database. When entering data in a VARCHAR column, you
must enclose it in single quotes(' '). Note that double-byte characters
occupy two bytes. If you are using double-byte characters you must account
for this when you specify the length of the column.
| e.g. |
'This
is a VARCHAR string.' |
| |
'This
is another VARCHAR string' |
<
TIMESTAMP | Contents
>
|