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 |
6 |
| 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 | 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 | 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 |