MySQL Forums
Forum List  »  GIS

Re: Difference between Well-Known Binary data format and MySql blob format
Posted by: dcarpenter
Date: November 13, 2005 11:13PM

Alexey Botchkov wrote:
> Presently, content of the GEOMETRY field is
> basically WKB with the SRID.
> But I wouldn't recommend to rely on that - we have
> plans to change that.
> If you need to get proper WKB of the object, you
> should use AsWKB function:
> SELECT AsWKB(geom_field) FROM geom_table;
>

If this SQL statement is passed to mysql_stmt_prepare(), the type of the column returned is a MYSQL_TYPE_VAR_STRING (rather than MYSQL_TYPE_GEOMETRY).

How do you then know that you should interpret the field data (ie. the MYSQL_BIND buffer field) as a well known binary formatted geometry ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Difference between Well-Known Binary data format and MySql blob format
4622
November 13, 2005 11:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.