Class | Category | Data Type (Synonyms) |
Character | Fixed length | character (char) |
Variable length | varchar (character varying) | |
long varchar (clob, character large object, char large object) | ||
Unicode | Fixed length | nchar |
Variable length | nvarchar | |
long nvarchar (clob, nclob, nchar large object, national character large object) | ||
Numeric | Exact numeric | integer (integer4, int) |
smallint (integer2) | ||
bigint (integer8) | ||
tinyint (integer1) | ||
decimal (dec, numeric) | ||
Approximate numeric | float (float8, double precision) | |
real (float4) | ||
Abstract | (none) | date |
money | ||
Binary | long byte (blob, binary large object) |