LONG VARCHAR
The LONG
VARCHAR data type is a variable length data type that can contain any
character you can enter from the keyboard. The maximum length of LONG
VARCHAR columns 2 gigabytes, or more than 2,000,000,000 characters.
Unlike the
CHAR data type which uses spaces for padding, only the characters entered
are stored in the database. When entering data in a LONG 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 LONG VARCHAR string.' |
| |
'This
is another LONG VARCHAR string' |
<
LONG VARBINARY | Contents
| OID >
|
