> The "What's new in MySQL 5.7" manual page [1] says:
>
>   *  InnoDB now supports spatial data types.
>
> What is the difference to previous releases in this respect?

The 5.7.1 Release Notes are a bit more specific:
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-1.html

InnoDB: Added support for spatial data types currently supported by
MySQL including POINT, LINE_STRING, POLYGON, MULTI_POINT,
MULTI_POLYGON, MULTI_LINE_STRING, GEOMETRY_COLLECTION, and GEOMETRY.

Prior to this release, InnoDB would store spatial data as binary BLOB
data. BLOB remains the underlying data type but spatial data types are
now mapped to a new InnoDB internal data type, DATA_GEOMETRY. With
BLOB as the underlying data type, a prefix index can still be used on
the GEOMETRY data column.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to