data
type 
aliases for compatibility
with other databases 
description 
value range 
save size
in bytes 
BOOLEAN 

boolean 
false and true 
1 
BIT 

integer number 
0 and 1 
1 
TINYINT 
BYTE 
integer number 
0 to 255 
1 
SMALLINT 

integer number 
32768 to 32767 
2 
INT 
COUNTER
(INT IDENTITY)
SERIAL
(INT IDENTITY) 
integer number 
2147483648 to 2147483647 
4 
BIGINT 

integer number 
9223372036854775808 to
9223372036854775807 
8 
REAL 

floating point number 
3.40E+38 to 3.40E+38 
4 
DOUBLE 

floating point number 
 1.79E+308 to 1.79E+308 
8 
FLOAT 

like DOUBLE 


MONEY 

fixed point number with a scale 4 
922,337,203,685,477.5808 to +922,337,203,685,477.5807 
8 
SMALLMONEY 

fixed point number with a scale 4 
214,748.3648 to 214,748.3647 
4 
NUMERIC[(p[,s])] 
NUMBER[(p[,s])]
VARNUM[(p[,s])] 
fixed point number with a variable precision and scale.
p  precision; the count of digits before and after the decimal point
s  scale ; the count of digits after the decimal point. 
depends on the precision and scale
precision 1  9
precision 10  19
precision 20  29
precision 30  39 
6
10
14
18 
DECIMAL[(p[,s])]


like NUMERIC 


CHAR[(n)] 
CHARACTER[(n)]

fixed length character data, all data are saved as unicode
n  length 
length from 1 to 65535 
2 + 2*n 
NCHAR[(n)] 

fixed length character data, all data are saved as unicode
n  length 
length from 1 to 65535 
2 + 2*n 
VARCHAR[(n)] 
VARCHAR2[(n)]

variable length character data, all data are saved as unicode
n  length

length from 0 to 65535 
variable
2 to
2 + 2*n 
NVARCHAR[(n)]

NVARCHAR2[(n)] 
variable length character data, all data are saved as unicode
n  length

length from 0 to 65535 
variable
2 to
2 + 2*n 
LONGVARCHAR 
TEXT LONG

variable length large character data, all data are saved as unicode 
length from 0 to 2,147,483,647 
12+2*n 
LONGNVARCHAR 
NTEXT

variable length large character data, all data are saved as unicode 
length from 0 to 2,147,483,647 
12+2*n 
CLOB 

large character data with handle, all data are saved as unicode 
length from 0 to 2,147,483,647 
12+2*n 
NCLOB 

large character data with handle, all data are saved as unicode 
length from 0 to 2,147,483,647 
12+2*n 
BINARY[(n)] 

fixed length binary data 
length from 1 to 65535 
2+n 
VARBINARY[(n)] 
RAW 
variable length binary data 
length from 1 to 65535 
variable
2 to 2+n 
LONGVARBINARY 
IMAGE LONG RAW 
variable length large binary data 
length from 0 to 2,147,483,647 
12+n 
BLOB 

large binary data with handle 
length from 0 to 2,147,483,647 
12+n 
DATE 

date 

4 
TIME 

time 

4 
TIMESTAMP 
DATETIME 
timestamp 

8 
SMALLDATETIME 

date and time with a precision of a minute 

4 
UNIQUEIDENTIFIER 

16 byte unique identifier 

16 
JAVA_OBJECT 
SQL_VARIANT 
any Java object 
size from 0 to 2,147,483,647 
variable 