LONG VARCHAR data type
Derby Reference Manual
200
INTEGER
Minimum value
-2147483648 (java.lang.Integer.MIN_VALUE)
Maximum value
2147483647 (java.lang.Integer.MAX_VALUE)
When mixed with other data types in expressions, the resulting data type follows the rules
shown in
See also
.
Examples
3453
425
LONG VARCHAR data type
The LONG VARCHAR type allows storage of character strings with a maximum length
of 32,700 characters. It is 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
When you are converting from Java values to SQL values, no Java type corresponds to
LONG VARCHAR.
LONG VARCHAR FOR BIT DATA data type
The LONG VARCHAR FOR BIT DATA type allows storage of bit strings up to 32,700
bytes. It is identical to
, except that you cannot specify a
maximum length when creating columns of this type.
Syntax
LONG VARCHAR FOR BIT DATA
JDBC metadata type (java.sql.Types)
LONGVARBINARY
NUMERIC data type
NUMERIC is a synonym for
and behaves the same way. See
.
Syntax
NUMERIC [(precision [, scale ])]
