|Type Name||Description||Value Range||NULL Value|
|short||16-bit signed integer data type||-32767 ~ 32767||-32768|
|ushort||16-bit unsigned integer type data type||0 ~ 65534||65535|
|integer||32-bit signed integer data type||-2147483647 ~ 2147483647||-2147483648|
|uinteger||32-bit unsigned integer data type||0 ~ 4294967294||4294967295|
|long||64-bit signed integer data type||-9223372036854775807 ~ 9223372036854775807||-9223372036854775808|
|ulong||64-bit unsigned integer data type||0~18446744073709551614||18446744073709551615|
|float||32-bit floating point data type||-||-|
|double||64-bit floating point data type||-||-|
|datetime||Time and date||1970-01-01 00:00:00 000:000:000 ~ 2262-04-11 23:47:16.854:775:807||-|
|varchar||Variable-length character strings (UTF-8)||Length : 1 ~ 32768 (32K)||-|
|ipv4||Version 4 Internet address type (4 bytes)||“0.0.0.0” ~ “255.255.255.255”||-|
|ipv6||Version 6 Internet address type (16 bytes)||“0000:0000:0000:0000:0000:0000:0000:0000” ~ “FFFF:FFFF:FFFF:FFFF:FFFF:FFFF:FFFF:FFFF”||-|
|text||Text data type (keyword index can be generated)||Length : 0 ~ 64M||-|
|binary||Binary data type (index creation not possible)||Length: 0 ~ 64M||-|
|json||json data type||json data length : 1 ~ 32768 (32K)|
json path length : 1 ~ 512
This is the same as the 16-bit signed integer data of the C language. For the minimum negative value, it is recognized as NULL. May be displayed as “int16”.
This is the same as 32-bit signed integer data in C language. For the minimum negative value, it is recognized as NULL. May be displayed as “int32” or “int”.
This is the same as 64-bit signed integer data in C language. For the minimum negative value, it is recognized as NULL. May be displayed as “int64”.
This is equivalent to the C 32-bit floating-point data type float. For a positive maximum value, it is recognized as NULL.
This is equivalent to the 64-bit floating-point data type double of C language. For a positive maximum value, it is recognized as NULL.
In Machbase, this type maintains the nano value of the time elapsed since midnight January 1, 1970.
Thus, Machbase provides the ability to process values up to nano units for all datetime type related functions.
This is a variable string data type and can be generated up to 32K bytes in length.
This length criterion is based on one character in English, so it is different from the actual number of characters to be output in UTF-8 and should be set to an appropriate length.
This type is a type that can store addresses used in Internet Protocol version 4.
It is internally represented using 4 bytes, and can be expressed from “0.0.0.0” to “255.255.255.255”.
This type is a type that can store addresses used in Internet Protocol version 6.
16 bytes are internally represented and can be expressed from “0000: 0000: 0000: 0000: 0000: 0000: 0000: 0000” to “FFFF: FFFF: FFFF: FFFF: FFFF: FFFF: FFFF: FFFF” . Since the abbreviation type is also supported when inputting data, it can be expressed as follows using the symbol :.
- “:: FFFF: 1232”: all leading with zeros
- “:: FFFF: 192.168.0.3”: Support for IPv4 type compatibility
- “:: 192.168.3.1”: Support for deprecated IPv4 type compatibility
This type is a data type for storing text or documents beyond the size of a VARCHAR.
This data type can be searched through keyword indexes and can store up to 64 megabytes of text. This type is mainly used to store and retrieve large text files as separate columns.
This type is a supported type for storing unstructured data in columns.
It is used to store binary data such as image, video, or audio. Indexes can not be created for this type. The maximum data size for storing is up to 64 megabytes, the same as the TEXT type.
This type is a data type for storing json data.
Json is a format to store data object, consisting of “Key-Value” pairs, into text format.
The maximum size of data is 32K bytes which is same as varchar type.
The following table shows the SQL data types and C data types corresponding to the mark base data types.
|Machbase Datatype||Machbase CLI Datatype||SQL Datatype||C Datatype||Basic types for C||Description|
|short||SQL_SMALLINT||SQL_SMALLINT||SQL_C_SSHORT||int16_t (short)||16-bit signed integer data type|
|ushort||SQL_USMALLINT||SQL_SMALLINT||SQL_C_USHORT||uint16_t (unsigned short)||16-bit unsigned integer type data type|
|integer||SQL_INTEGER||SQL_INTEGER||SQL_C_SLONG||int32_t (int)||32-bit signed integer data type|
|uinteger||SQL_UINTEGER||SQL_INTEGER||SQL_C_ULONG||uint32_t (unsigned int)||32-bit unsigned integer data type|
|long||SQL_BIGINT||SQL_BIGINT||SQL_C_SBIGINT||int64_t (long long)||64-bit signed integer data type|
|ulong||SQL_UBIGINT||SQL_BIGINT||SQL_C_UBIGINT||uint64_t (unsigned long long)||64-bit unsigned integer data type|
|float||SQL_FLOAT||SQL_REAL||SQL_C_FLOAT||float||32-bit floating point data type|
|double||SQL_DOUBLE||SQL_FLOAT, SQL_DOUBLE||SQL_C_DOUBLE||double||64-bit floating point data type|
|char * (YYYY-MM-DD HH24:MI:SS)|
int64_t (timestamp: nano seconds)
|Time and date|
|ipv4||SQL_IPV4||SQL_VARCHAR||SQL_C_CHAR||char * (enter ip string)|
|Version 4 Internet address type|
|ipv6||SQL_IPV6||SQL_VARCHAR||SQL_C_CHAR||char * (enter ip string)|
|Version 6 Internet address type|
|binary||SQL_BINARY||SQL_BINARY||SQL_C_BINARY||char *||Binary data|
|json||SQL_JSON||SQL_JSON||SQL_C_CHAR||json_t||json data type|