Unsupported data types and operators
Updated at:
Copy as MD
The following MySQL data types and operators are not supported in AnalyticDB for MySQL. Review this list before migrating schemas or SQL to identify areas that require changes.
Unsupported data types
| Item | Data type |
| Numeric type | BIT |
| DEC | |
| UNSIGNED Note Unsigned numbers are not supported. |
|
| String type | TINYBLOB |
| MEDIUMBLOB | |
| LONGBLOB | |
| Spatial data type | GEOMETRY |
| LINESTRING | |
| POLYGON | |
| MULTIPOINT | |
| MULTILINESTRING | |
| MULTIPOLYGON | |
| GEOMETRYCOLLECTION | |
| Complex data type | ENUM |
| SET |
Unsupported operators
| Operator | Description |
|---|---|
:= | Assignment |
~ | Bitwise negation |
Is this page helpful?