Overview

This topic describes the MySQL data types, including their attributes and storage requirements, supported by OceanBase Database V4.3.3.

OceanBase Database V.3.3 supports the following MySQL data types:

• Numeric types

• Datetime types

• String types

• Large object types

• Text types

• ENUM type

• SET type

• JSON data types

• Spatial data types

• Roaring bitmap data type

• Array data type

OceanBase Database allows you to compare data of any two or more data types. Possible comparison results are as follows:

• Nonzero value or TRUE

• 0 or FALSE

• NULL

To compare data of different data types, OceanBase Database chooses a data type as the reference based on related rules. All the data to be compared must be logically converted into the reference data type before comparison. If a text type is chosen as the reference, a collation is also required.

For information about the conversion rules, see Convert data types in expression evaluation.