Sample Header Ad - 728x90

Mysql 8 ST_GeomFromText giving error Latitude out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]

11 votes
2 answers
6880 views
I am trying the following insert query on mysql 8. Insert Into fence Set fenceName='aa', radius=2, fenceGeometry=ST_GeomFromText('POINT(102.1893310546875 3.880696482497261)', 4326) It works perfectly on mysql 5.7 but here in mysql 8 I get this error Latitude 102.189331 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]. Based on some suggestion I also did this. ALTER TABLE fence MODIFY fenceGeometry geometry NOT NULL SRID 4326; But yet the it gives me the same results.
Asked by newbie (217 rep)
Jul 3, 2019, 04:44 PM
Last activity: Jun 29, 2022, 03:35 PM