3. OpenSQL Data Types
 
Share this page                  
OpenSQL Data Types
OpenSQL Data Types
The following table lists the OpenSQL data types:
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)