Re: mysql as a spatial database backend

2004-04-23 Thread James S reid
Ive posted thsi query twice and got no reply - Im sure somebody must know thw answer!!! whast the field length limitations for insertion of a WKT string into a geometry column? yours, close to giving up james -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Fw: spatial woes - again

2004-04-21 Thread James S reid
hi - Ive posted this before but not had any answers... Im trying to load spatial data as OGC WKT into a geometry field but a number of rows consistently fail. I can se no reaspn for this other than their length - does anyone know what the size limit for insertion into a geometry field is (Im lo

spatial woes

2004-04-19 Thread James S reid
hi - Ive posted this before but not had a satisfactory solution... Im trying to load spatial data as OGC WKT into a geometry field but a number of rows consistently fail. I can se no reaspn for this other than their length - does anyone know what the size limit for insertion into a geometry field

spatial types

2004-01-13 Thread James S reid
hi - ive been playing with the OGC support for WKT but cant find data type size constraints for GEOMETRY types. does anybody know what they are? Ive a polygon with > 140,000 bytes as WKT but inserts all produce a NULL geometry... any ideas? regards "Programming today is a race between softw