views:

179

answers:

1
+---------+---------+------+-----+---------+----------------+
| Field   | Type    | Null | Key | Default | Extra          |
+---------+---------+------+-----+---------+----------------+
| id      | int(11) | NO   | PRI | NULL    | auto_increment |
| user_id | int(11) | NO   | UNI | NULL    |                |
| utm     | point   | NO   | MUL | NULL    |                |
+---------+---------+------+-----+---------+----------------+

insert into life(user_id, utm)  values(99,point(4,4));

ERROR 1416 (22003): Cannot get geometry object from data you send to the GEOMETRY field
+2  A: 

Have you tried:

insert into life(user_id, utm)  values(99,PointFromWKB(POINT(4,4)));
f3lix
According to http://bit.ly/9r97o5, this is only required on MySQL versions prior to 5.1.35. Starting with 5.1.35, you can insert the return value from Point() directly.
Michael Madsen
Are function names case sensitive in mySQL?
Pekka
Did you mean MySQL? :D
huff