MySQL Spatial Data Types

[normancesar]

Hi,

We have recently added some Spatial Data Types to our MySQL database and it caused some issues (models failed).

A quick search found the issue raised about SQL Server
https://groups.google.com/forum/#!topic/cfwheels/eO2N9YITEac

And the fix by xxrxndxvxs (Aaron) and implemented by ellor1138 in #145.

I found implementing a similar fix in /wheels/models/adapters/MySQL.cfc fixed my issues.

I have added all the Spatial Data Types listed here to return as binary
https://dev.mysql.com/doc/refman/5.7/en/spatial-datatypes.html

Here is the code snippet change in $getType().

case "binary": case "geometry": case "point": case "linestring": case "polygon": case "multipoint": case "multilinestring": case "multipolygon": case "geometrycollection":
                    loc.rv = "cf_sql_binary";
                    break;

Thanks

Norman