Data types

This chapter describes the data types supported by the current version of seekdb, including their properties and storage requirements.

The current version of seekdb supports the following data types:

• Numeric types

• Date and time types

• String types

• Large object types

• Text types

• Enumeration types

• Set types

• JSON data types

• Spatial data types

• Efficiently compressed bitmap data types

• Array data types

• Map data types

seekdb allows you to compare two or more data values of any type. The result of the comparison can be:

• Nonzero / TRUE

• Zero / FALSE

• NULL

If the data types of the values being compared are different, seekdb determines a common data type for comparison based on the rules. Logically, all data values involved in the comparison must be converted to this data type before the comparison operation. If the comparison type is a text type, you must also determine a collation for the comparison.

For more information about the type conversion rules for comparison operations, see Type conversion during expression evaluation.