>
> 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

Reply via email to