You did an insert this way:
mysql> insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql> select AsText(g) from geom; +-----------+ | AsText(g) | +-----------+ | Point(1 1)| +-----------+ 1 row in set (0.00 sec)
The formatting of the POINT coordinates are different. I think you should be inserting "POINT (1 1)" not "POINT(1,1)". It is the comma.
-steve-
That's exactly right.
Was there an example like this in the manual that incorrectly included the comma?
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]