CHAR(size)
The CHAR
data type is a fixed length data type that can contain any character you
can enter from the keyboard. The minimum length of CHAR columns is 1 character,
and the maximum length is 3992 characters. You must enter a value for
the size parameter when creating a CHAR column.
Any data
entered in a CHAR column that is shorter than the column length is padded
with spaces. When entering CHAR data, 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 CHAR string.' |
| |
'This
is another CHAR string' |
<
BINARY | Contents
| DATE >
|
