SmallSQL Data Types

 

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

 

 

 

 

 

 


100% pure Java DBMS
Mirror Site