I tried it with an 854kb WKT block with out any problems. A total of 64k
points in fact. Two things, did you correctly close the polygon (first
and last points must be the same). Did you use the astext() function to
display the polygon in your select statement?
CREATE TABLE big (
g geometry NOT NULL default '',
spatial index (g(12))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Sample sql was 854k bytes (took 136 sec. to insert):
insert into big (g)
values(
GeomFromText('polygon((
1 1,
2 2,
3 3,
...
63999 63999,
64000 64000,
64000 1,
1 1
))')
)
The Query:
select astext(g) from big
Sample Results (took .5 sec. to return):
POLYGON((1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9,10 10,
11 11,12 12,13 13,14 14,15 15,16 16,17 17,18,19 19,
....
63998 63998,63999 63999,64000 64000,64000 1,1 1))
The big.MYD was 1meg in size.
Ed
-----Original Message-----
From: James S reid [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 5:59 AM
To: [EMAIL PROTECTED]
Subject: spatial types
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 software engineers striving
to build bigger and better idiot-proof programs, and the Universe
trying to produce bigger and better idiots.
So far, the Universe is winning."
Rich Cook
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
