LONG VARCHAR

The LONG VARCHAR type allows storage of character strings with a maximum length of 32,670 characters. It is almost identical to VARCHAR, except that you cannot specify a maximum length when creating columns of this type.

Syntax

LONG VARCHAR

Corresponding Compile-time Java Type

java.lang.String

JDBC Metadata Type (java.sql.Types)

LONGVARCHAR

Usage Notes

When you are converting from Java values to SQL values, no Java type corresponds to LONG VARCHAR.