MySQL supports spatial data types but OceanBase Database does not. This topic describes these spatial data types.
Spatial data types
MySQL supports the following spatial data types: POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRY, and GEOMETRYCOLLECTION.
| Data type | Description |
|---|---|
| POINT | Stores a point. |
| LINESTRING | Stores a line. |
| POLYGON | Stores a polygon. |
| MULTIPOINT | Stores multiple points. |
| MULTILINESTRING | Stores multiple lines. |
| MULTIPOLYGON | Stores multiple polygons. |
| GEOMETRY | Stores data of the POINT, LINESTRING, or POLYGON type. |
| GEOMETRYCOLLECTION | Stores a collection of objects of any spatial data types. |