MySQL Forums
Forum List  »  GIS

Size of geometry columns?
Posted by: Mark Dixon
Date: November 17, 2006 11:56AM

In a table of polygons of California counties, one is unusually large (around 100K characters in WKT) and gets truncated in the geometry column. The rest of the polygons work fine.

It's my understanding that geometry columns are stored as BLOBs, which would make sense as it would truncate at 65K characters. Is there any way to change the size of the geometry column so that it will accomodate larger polygons, i.e., tell MySQL to store it as a MEDIUMBLOB or LONGBLOB instead of a BLOB?



Edited 1 time(s). Last edit at 11/17/2006 01:00PM by Mark Dixon.

Options: ReplyQuote


Subject
Views
Written By
Posted
Size of geometry columns?
4866
November 17, 2006 11:56AM
2728
December 01, 2006 06:51AM


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.