Fraser MacLeod <[EMAIL PROTECTED]> wrote:
>
> I have set up mySQL 4.1 and everything seems to work fine. I have created a
> database, and populated it, queried it, etc. Now I would like to add spatial
> data (points, lines, polygons);
>
> Using a mysql client I am able to insert spatial values into a table using WKT
> representation. Similarly I can query these columns, but the result is always
> [NULL].
>
> For example:
>
> SELECT AsText(PointFromText('POINT(10,10)'))
Remove comma from the POINT definition.
mysql> SELECT AsText(PointFromText('POINT(10 10)'));
+---------------------------------------+
| AsText(PointFromText('POINT(10 10)')) |
+---------------------------------------+
| POINT(10 10) |
+---------------------------------------+
1 row in set (0.00 sec)
>
> will return [NULL]
>
> Any ideas what I need to do to fix this problem
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
