Class | Category | Data Type |
Character | Fixed length | c |
char (character) | ||
Varying length | text | |
varchar (character varying) | ||
long varchar (clob, character large object, char large object) | ||
Unicode | Fixed length | nchar |
Varying length | nvarchar | |
long nvarchar (nclob, nchar large object, national character large object) | ||
Numeric | Exact numeric | integer (integer4) |
smallint (integer2) | ||
bigint (integer8) | ||
tinyint (integer1) | ||
decimal | ||
Approximate numeric | float (float8, double precision) float4 (real) | |
Date/time | Date | date |
ansidate | ||
ingresdate | ||
Time | time (time without time zone) time with time zone time with local time zone | |
Timestamp | timestamp (timestamp without time zone) timestamp with time zone timestamp with local time zone | |
Interval | interval year to month interval day to second | |
Abstract | (none) | money |
Logical key | object_key table_key | |
Binary | byte (binary) | |
varbyte (varbinary) | ||
long byte (blob, binary large object) | ||
Boolean | Logical | boolean |
Spatial | point | |
linestring | ||
polygon | ||
geometrycollection | ||
multipoint | ||
multilinestring | ||
multipolygon |