{"id":245,"date":"2011-06-04T11:19:05","date_gmt":"2011-06-04T11:19:05","guid":{"rendered":"http:\/\/www.sitekickr.com\/blog\/?p=245"},"modified":"2011-06-04T11:19:44","modified_gmt":"2011-06-04T11:19:44","slug":"mysql-polygon-returns-null","status":"publish","type":"post","link":"https:\/\/www.sitekickr.com\/blog\/mysql-polygon-returns-null\/","title":{"rendered":"MySQL GeomFromText Polygon returns null"},"content":{"rendered":"<p>Trying to add a <em>POLYGON<\/em> using <em>GeomFromText<\/em>? I don&#39;t know about you, but although it&#39;s documented as being able to &quot;construct a geometry value of any type&quot;, I&#39;m getting NULLs returned.<\/p>\n<p>Ex:<\/p>\n<p><code>Select GeomFromText(&#39;POLYGON((0 0, 0 200, 200 200, 0 0))&#39;);<\/code><br \/>\n\tNULL<\/p>\n<p>By narrowing down to the PolygonFromText function &#8211; we get some results:<\/p>\n<p><code>Select PolygonFromText(&#39;POLYGON((0 0, 0 200, 200 200, 0 0))&#39;)<\/code><\/p>\n<p>Binary value returned<\/p>\n<p>&nbsp;<\/p>\n<p>This might seem obvious &#8211; but almost every tutorial \/ example I&#39;ve seen suggest the use of GeomFromText. It may be the version of MySQL that I&#39;m running, but I thought I&#39;d share.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trying to add a POLYGON using GeomFromText? I don&#39;t know about you, but although it&#39;s documented as being able to &quot;construct a geometry value of&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[77,13],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/245"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=245"}],"version-history":[{"count":3,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/245\/revisions"}],"predecessor-version":[{"id":248,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/245\/revisions\/248"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}