Data types

This topic describes the data types supported by OceanBase Database in MySQL mode and their attributes and storage requirements.

OceanBase Database supports the following data types in MySQL mode:

• Numeric types

• Date and time types

• Character types

• Large object types

• Text types

• Enumeration types

• Set types

• JSON data types

• Spatial data types

• Roaring bitmap data types

• Array data types

• Map data types

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

• A nonzero value or TRUE

• 0 or FALSE

• NULL

If the data types of the values being compared are different, OceanBase Database determines a data type for comparison based on the relevant rules. All values involved in the comparison must be converted to this data type before the comparison can be performed. If the comparison type is a text type, a collation must also be determined for the comparison.

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