HP 3000 Manuals HP 3000 Manuals
Chapter 3 ALLBASE/SQL Data Types
ALLBASE/SQL Data Types
----------------------------------------------------------------------------------------------
| | | |
| Group | Data Type | Description |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Alpha- | CHAR[ACTER][(n)] | String of fixed length n, where n is an integer |
| numeric | | from 1 to 3996 bytes. The default size is CHAR |
| | | (1). The keyword CHARACTER is a synonym for CHAR. |
| | | |
| | VARCHAR(n) | String of variable length no greater than n, where |
| | | n must be an integer from 1 to 3996 bytes. |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Numeric | DEC[IMAL][(p[,s])] | Fixed-point packed decimal number with a precision |
| | NUMERIC[(p[,s])] | (maximum number of digits excluding sign and |
| | | decimal point) no greater than p, where p is 1 |
| | | through 15, and a scale (number of digits to the |
| | | right of the decimal) of s, where s is from 0 |
| | | through p. E (exponential) and L (Pascal longreal) |
| | | notation are not allowed in the specification of a |
| | | decimal value. Operations on data of type DECIMAL |
| | | are often much more precise than operations on data |
| | | of type FLOAT. |
| | | |
| | | The default for NUMERIC and DECIMAL types is |
| | | DECIMAL (15,0). DEC and NUMERIC are synonyms for |
| | | DECIMAL. |
| | | |
----------------------------------------------------------------------------------------------
Table 3-0. ALLBASE/SQL Data Types (cont.)
----------------------------------------------------------------------------------------------
| | | |
| Group | Data Type | Description |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Numeric | FLOAT[(p)] or DOUBLE | Long (64-bit) floating point number. This is an |
| (continued) | PRECISION | approximate numeric value consisting of an exponent |
| | | and a mantissa. The precision, p, is a positive |
| | | integer that specifies the number of significant |
| | | binary digits in the mantissa. The value of p can |
| | | be from 25 to 53. The default is 53. |
| | | |
| | | The range of negative numbers that can be |
| | | represented is -1.79769313486230E+308 to |
| | | -2.22507385850721E-308. The range of positive |
| | | numbers that can be represented is |
| | | 2.22507385850721E-308 to 1.79769313486230E+308. E |
| | | (exponential) or L (Pascal longreal) notation can |
| | | be used to specify FLOAT values. |
| | | |
| | | DOUBLE PRECISION is a synonym for FLOAT(53). |
| | | |
| | FLOAT(p) or REAL | Short (32-bit) floating point number. This is an |
| | | approximate numeric value consisting of an exponent |
| | | and a mantissa. The precision, p, is a positive |
| | | integer that specifies the number of significant |
| | | binary digits in the mantissa. The value of p can |
| | | be from 1 to 24. The default (using REAL) is 24. |
| | | The range of negative numbers that can be |
| | | represented is -3.402823E+38 to -1.175495E-38. The |
| | | range of positive numbers that can be represented |
| | | is 3.402823E+38 to 1.175495E-38. |
| | | |
| | | REAL is a synonym for FLOAT (24). |
| | | |
| | INT[EGER] | Integer in the range -2147483648 (-231) to |
| | | 2147483647 (231-1). INT is a synonym for INTEGER. |
| | | |
| | SMALLINT | Integer in the range -32768 (-215) to 32767 |
| | | (215-1). |
| | | |
----------------------------------------------------------------------------------------------
Table 3-0. ALLBASE/SQL Data Types (cont.)
----------------------------------------------------------------------------------------------
| | | |
| Group | Data Type | Description |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Date/Time | DATE | String of form 'YYYY-MM-DD' where YYYY represents |
| | | the calendar year, MM is the month, and DD is the |
| | | day of the month. DATE is in the range from |
| | | 0000-01-01 to 9999-12-31. |
| | | |
| | TIME | String of the form 'HH:MI:SS' where HH represents |
| | | hours, MI is minutes, and SS is seconds. TIME is |
| | | in the range from 00:00:00 to 23:59:59. |
| | | |
| | DATETIME | String of the form 'YYYY-MM-DD HH:MI:SS.FFF' where |
| | | YYYY represents the calendar year, MM is the month, |
| | | DD is the day, HH the hour, MI the minute, SS the |
| | | second, and FFF thousandths of a second. The range |
| | | is from 0000-01-01 00:00:00.000 to 9999-12-31 |
| | | 23:59:59.999. |
| | | |
| | INTERVAL | String of the form 'DDDDDDD HH:MI:SS.FFF' where |
| | | DDDDDDD is a number of days, HH a number of hours, |
| | | MI a number of minutes, SS a number of seconds, and |
| | | FFF a number of thousandths of a second. The range |
| | | is from 0 00:00:00.000 to 3652436 23:59:59.999. |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Binary | BINARY(n) | Binary string of fixed length n, where n is an |
| | | integer from 1 to 3996 bytes. Each byte stores 2 |
| | | hex digits. |
| | | |
| | VARBINARY(n) | Binary string of variable length no greater than n, |
| | | where n is an integer from 1 to 3996 bytes. Each |
| | | byte stores 2 hex digits. |
| | | |
| | LONG BINARY(n) | Binary string of fixed length n, where n is an |
| | | integer from 1 to (231-1) bytes. |
| | | |
| | LONG VARBINARY(n) | Binary string of variable length no greater than n, |
| | | where n is an integer from 1 to (231-1) bytes. |
| | | |
----------------------------------------------------------------------------------------------