HP Driver for JDBC User's Manual

62 AppendixA
Data Types
ALLBASE/SQL Data Types
ALLBASE/SQL Data Types
SMALLINT 16-bit signed integer.
INTEGER 32-bit signed integer.
NUMERIC Fixed-point, packed, decimal number
with a specified precision of p and scale
of s, where p is in the range 1 to 27,
and s is in the range 0 to p. The default
value of p is 27 and s is 0.
DECIMAL Identical to NUMERIC.
REAL 32-bit floating-point number.
FLOAT A floating-point number with a
precision of p where p is in the range 1
to 53. The default value of p is 53. If
the value of p is from 1 to 24, the value
is treated as a 32-bit floating-point
number. If the value of p is from 25 to
53, the value is treated as a 64-bit
floating-point number.
DOUBLE 64-bit floating-point number.
CHAR String of characters of fixed-length n
where n is in the range 1 to 3996 bytes.
Space characters are used to pad any
strings of length less than n to
length n.
VARCHAR String of characters of variable-length
up to length n where n is in the range 1
to 3996 bytes.
DATE String of characters in the format
“YYYY-MM-DD” where YYYY represents
the calendar year, MM is the month, and
DD is the day of month. DATE is in the
range from “0000-01-01” to
“9999 12-31”.
TIME String of characters in the format
“HH:MI:SS” where HH represents
hours, MI is minutes, and SS is seconds.
TIME is in the range “00:00:00” to
“23:59:59”