Data Type

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