SQL-J Language Reference
Page 102 of 121

LONG VARCHAR

The LONG VARCHAR type allows storage of bit strings of unlimited length. It is identical to VARCHAR, except that you do not have to specify a maximum length when creating columns of this type.

NOTE: For locale-sensitive sorts and other operations, use the LONG NVARCHAR data type. For more information, see International String Data Types.

Syntax for Column Definition

LONG VARCHAR

Corresponding Compile-Time Java Type

java.lang.String

JDBC Metadata Type (java.sql.Types)

LONGVARCHAR

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