MySQL Forums
Forum List  »  GIS

Advanced Search
New Topic

Difference between Well-Known Binary data format and MySql blob format
Posted by: Diego Guidi
Date: February 03, 2005 05:15AM

For my tests, MySql memorize geometry data as binary format (BLOB) like WKB, but with some differences...

as example:
Well-Known Text: POINT(10 10)
Well-Known Binary: Int32Byteorder + Int32GeometryType DoubleXCoord + DoubleXCoord (4 + 4 + 8 + 8 = 24 bytes)

MySqlBlob Binary: Int32Byteorder + CharUnknown + Int32GeometryType DoubleXCoord + DoubleXCoord (4 + 1 + 4 + 8 + 8 = 25 bytes)

It's correct my interpretation? And who mean the char?

Thanks for responses :)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Difference between Well-Known Binary data format and MySql blob format
8434
Diego Guidi
February 03, 2005 05:15AM
Re: Difference between Well-Known Binary data format and MySql blob format
3397
Diego Guidi
February 03, 2005 07:45AM
Re: Difference between Well-Known Binary data format and MySql blob format
3194
Chris Wood
July 21, 2005 11:19PM
Re: Difference between Well-Known Binary data format and MySql blob format
3322
Alexey Botchkov
August 02, 2005 01:24AM
Re: Difference between Well-Known Binary data format and MySql blob format
4700
dcarpenter
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.