CODEWITHSUNDEEP
mysqlpolygon
Biwu
Biwu

Reputation: 103

Inserting polygon to mysql returns null

When I run

INSERT INTO zones (userId, typeId, name, coords, date) VALUES
(2, 3, "Name", PolygonFromText('POLYGON((41,395210 2,134008,41,385615 2,142463,41,393085 2,131133,41,385310 2,138665,41,395210 2,134008))'), now());

it returns NULL

I created a few polygons before with any problem. The difference is that coords have less digits than working ones.

Upvotes: 0

Views: 863

Answers (1)

Biwu
Biwu

Reputation: 103

Ok, the problem was that comas. Coords need to be like this:

41.395210 2.134008

Not like this:

41,395210 2,134008

I feel so stupid...

Upvotes: 1

Related Questions