 |
 |
|
|
|
|
|
|
|
|
Data Type
|
Description
|
|
VARCHAR{size}
|
Character of maximum length size. The default size is 1. The maximum size is 32,767.
|
|
NUMERIC{precision{,scale}}
|
A decimal number with precision total digits and with scale of the digits after the decimal point. The default for precision is 30 and for scale is 6.
|
|
INTEGER{size}
|
Signed integer, maximum size 2,147,483,647. Abbreviated form is INT.
|
|
SMALLINT
|
Signed integer of maximum value 32,767.
|
|
BINARY{size}
|
Binary data of maximum length size. The default size is 1. The maximum size is 32,767. The binary data type is identical to the CHAR data type except when used in comparisons. Binary character are compared exactly; CHAR values are not case sensitive.
|
|
LONG BINARY
|
Binary data of maximum length 32,767. The binary data type is identical to the CHAR data type except when used in comparisons. Binary character are compared exactly; CHAR values are not case sensitive.
|
|
DATE
|
A calendar date (year, month, and day). A data column can contain a time but you should use TIMESTAMP for anything with a date, hours, and minutes.
|
|
TIME
|
A time of day, containing hour, minute, second, and a fraction of a second. The fraction is stored to 6 decimal places.
|
|
TIMESTAMP
|
A point in time, containing year, month, day, hour, minute, second, and a fraction of a second. The fraction is stored to 6 decimal places.
|
|
FLOAT
|
A single precision floating point number. Range 1.175494351e-38 to 3.402823466e+38.
|
|
LONG VARCHAR
|
Character of maximum length 32,767.
|
|
DOUBLE
|
A double precision floating point number. Range 2.2250738585070160e-308 to 1.79769313486231560e+308
|
|
CHAR{size}
|
Character of maximum length size. The default size is 1. The maximum size is 32,767.
|
|
|
|
|
|
|
|
|
|
|
