Tell me more ×  I'd like to store some geometric positions in my
MySQL database. For this I use the POINT datatype. Almost
everywhere I read that the function GeomFromText should be used
to insert data in the table.  However, I found out that
POINT(X,Y) also works. I didn't find any description why
GeomFromText should be used instead of POINT.  For example I
have the following simple relation:      Position    POINT  And
I can insert values using the following two variants:
GeomFromText( 'POINT(48.19976 16.45572)' )      POINT(48.19976,
16.45572)  When I view the table (SELECT * FROM Site) I see the
same binary blob for the location, and when I view the
coordinates (SELECT *, AsText(Position) FROM Site) I also see
the same values.  So why should GeomFromText be used? Are there
any (known) performance differences between these two variants?
How is this solved in other database systems than MySQL?
share|improve this question I don't know if there are any
performance differences (I'd guess not but that's a