This chapter describes the MySQL data types supported by the current version of OceanBase AI Database, including their attributes and storage requirements.
The current version of OceanBase AI Database supports the following MySQL data types:
OceanBase AI Database allows you to compare any two or more data items of arbitrary types. The comparison results can be as follows:
Non-zero /
TRUE0 /
FALSENULL
If the data types of the elements to be compared are inconsistent, OceanBase AI Database determines a common data type for the comparison based on relevant rules. Logically, all data to be compared must first be converted to this common type before the comparison can proceed. If the comparison involves text data, an appropriate collation for the comparison must also be determined.
For conversion rules of comparison operators, see Data type conversion rules.