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)