ALLBASE/SQL Data Types

16-bit signed integer.

32-bit signed integer.

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.

Identical to NUMERIC.

32-bit floating-point number.

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.

64-bit floating-point number.

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.

String of characters of variable-length up to length n where n is in the range 1 to 3996 bytes.

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".

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"

String of characters in the format " YYYY-MM-DD HH:MI:SS.FFF" where YYYY represents the calendar year, MM is the month, DD is the day of the month, HH is the hour, MI is the minute, SS is the second, and FFF is the thousandth of a second. DATETIME is in the range "0000-01-01 00:00:00.000" to "9999-12-31 23:59:59.999".

String of characters in the format " DDDDDDD HH:MI:SS.FFF" where DDDDDDD is a number of days, HH is a number of hours, MI is a number of minutes, SS is a number of seconds, and FFF is a number of milliseconds. INTERVAL is in the range "0 00:00:00.000" to "3652436 23:59:59.999".

Binary string of fixed-length n where n is in the range of 1 to 3996 bytes. Each byte stores 2 hexadecimal digits.

Binary string of variable-length up to length n where n is in the range of 1 to 3996 bytes. Each byte stores 2 hexadecimal digits.

Binary string of fixed-length up to length n where n is in the range of 1 to (2³¹-1) bytes. This data type is currently not supported by the HP Driver for JDBC.

Binary string of variable-length up to length n where n is in the range of 1 to (2³¹-1) bytes. This data type is currently not supported by the HP Driver for JDBC.