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.
SQL Datatype Table
The following table shows the SQL data types and C data types corresponding to the mark base data types.
Machbase CLI Datatype
Basic types for C
16-bit signed integer data type
uint16_t (unsigned short)
16-bit unsigned integer type data type
32-bit signed integer data type
uint32_t (unsigned int)
32-bit unsigned integer data type
int64_t (long long)
64-bit signed integer data type
uint64_t (unsigned long long)
64-bit unsigned integer data type
32-bit floating point data type
64-bit floating point data type
char * (YYYY-MM-DD HH24:MI:SS )
int64_t (timestamp: nano seconds)
Time and date
char * (enter ip string)
Version 4 Internet address type
char * (enter ip string)
Version 6 Internet address type