Thanks for the info, Larry :) I will use the DB types. Nicolas
On 28 December 2015 at 17:10, Larry Reeder <lnree...@gmail.com> wrote: > > >> 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 > >
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
