{"id":14034834,"date":"2021-02-11T09:22:07","date_gmt":"2021-02-11T09:22:07","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/zero-as-integer-not-string\/"},"modified":"2021-02-11T09:22:07","modified_gmt":"2021-02-11T09:22:07","slug":"zero-as-integer-not-string","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/zero-as-integer-not-string\/","title":{"rendered":"Zero as integer &#8211; not string"},"content":{"rendered":"<p>Hello, I&#8217;m using a seperate database to create a table. The data is integers, but when I make an SQL-query (e.g. SELECT * FROM <code>test<\/code> WHERE <code>fruit<\/code>=&#8221;Apple&#8221;) it formats all zero values to strings instead of integers. When I try to make a line graph it doesn&#8217;t work since it is a mix of integer and string data (Error message: &#8220;Please do not add more then one string-type&#8221;). Is there a way to make zeroes default to integers and not strings?<\/p>\n","protected":false},"template":"","class_list":["post-14034834","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14034834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14034834\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14034834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}