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
Last activity: Jun 29, 2022, 03:35 PM