Title: Zero as integer – not string
Last modified: February 11, 2021

---

# Zero as integer – not string

 *  Resolved [siljerud](https://wordpress.org/support/users/siljerud/)
 * (@siljerud)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/zero-as-integer-not-string/)
 * Hello, I’m using a seperate database to create a table. The data is integers,
   but when I make an SQL-query (e.g. SELECT * FROM `test` WHERE `fruit`=”Apple”)
   it formats all zero values to strings instead of integers. When I try to make
   a line graph it doesn’t work since it is a mix of integer and string data (Error
   message: “Please do not add more then one string-type”). Is there a way to make
   zeroes default to integers and not strings?

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/zero-as-integer-not-string/#post-14039859)
 * Hi siljerud,
 * Sorry for the trouble,
 * Based on your explanation we can see that you are using SQL queries which is 
   the feature of the premium version.
 * On this forum is not allowed support for the premium version, so please contact
   us on [our support platform](https://tmsplugins.ticksy.com/) by choosing wpdatatables
   category and our support agents will help you out.
 * Thank you for understanding.
 * Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Zero as integer – not string’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/zero-as-integer-not-string/#post-14039859)
 * Status: resolved