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?