Scimore SQL Data Types

Internal Id	Type Names	Storage Requirement	Limits	Type description
2	TINYINT, SMALLINT	2 bytes	-32,768 to 32,767	Signed integer
3	INT, INTEGER	4 bytes	-2,147,483,648 to 2,147,483,647	Signed integer
32769	BIGINT	8 bytes	2^63 to 2^63 -1	Signed long integer
4	FLOAT	4 bytes	+/- 3.4E +/- 38 (7 digits)	Floating point value
5	DOUBLE	8 bytes	+/- 1.7E +/- 308 (15 digits)	Double float value
6	DATETIME	8 bytes	0100-01-01 00:00:00 to 9999-31-12 23:59:59	Date-Time value. Format: Year/Month/Day Hour:Min:Sec. Example: 19/01/1972 12:20:00
8	CHAR, VARCHAR	Length of string + 1 byte for zero terminator	size up to 8 KB	String of text characters. Cannot contain a null characters.
72	GUID	16 bytes	0 to 2^128 -1	Globally unique identifier
32768	UNIQUEIDENTIFIER	8 bytes	0 to 2^64 -1	Automatically incrementing column. Unpredictable, subsequent values will always be higher than previous. Cannot be set by the user.
32771	BLOB	size of data	32 TB	Any binary character data
32770	TEXT	size of text	32 TB	Any text character data
25	NCHAR, NVARCHAR	2 * Length of string + 1 byte for zero terminator	4kb	Unicode text
32772	NTEXT	Size of unicode text	32 TB	Unicode text

TEXT and NTEXT has built-in compression. ScimoreDB automatically evaluates if its possible to save storage and compress if it benefits size.

Related