Overview

This topic describes the MySQL data types, including their attributes and storage requirements, supported by the current version of OceanBase Database.

In the current version, OceanBase Database supports the following MySQL data types:

• Numeric data types

• Datetime data types

• Character data types

• BLOB data types

• TEXT data types

• ENUM data type

• SET data type

• JSON data type

• Spatial data type

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

• Non-0 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 to evaluate expressions.