Since MySQL 5.8 the function GeomFromText()
is no longer available and one should use ST_GeomFromText()
instead, which works exactly the same. Progress, of course :-(
Ref: https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html#function_geomfromtext
Now I'd like to use this function in a way that is backwards compatible so it can run on very old MySQL server versions as much as possible. What is the best way to check if this function is defined and which of the two (if any) I can use? I'd like to prevent having to check the version number of the server to select the correct query, if at all possible.