> > Larry, DBQuery assumes the MySQL binary format stores 4 "0" bytes at the > beginning, which is the case only when a geometry is built with no SRID or > SRID set to 0: > > Thanks for the info, Nicolas. I couldn't find any docs for the MySQL binary format at the time I was writing the plugin, and had to reverse-engineer the binary format, so didn't know those bytes were for SRIDs at the time.
Regarding detecting OGC WKB format versus native MySQL format, newer versions of MySQL (post MySQL 5.0.8?) JDBC drivers and/or DB mark a native geometry column as type "GEOMETRY" in the metadata, which should allow you to distinguish between a native geometry type or someone storing WKB as a BLOB. -lreeder
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel