fbwb
-
Posts
3 -
Joined
-
Last visited
Never
fbwb's Achievements
Newbie (1/5)
0
Reputation
-
MySql returns integers as strings - how to return as integers?
fbwb replied to fbwb's topic in MySQL Help
The problem ist that I am converting the data to JSON with json_encode, and numbers the difference is: "id":3 vs. "id":"3" The client reading the JSON doesn't accept the number as a string ("3"). And I have a lot of different tables, so it's very cumbersome to go through all columns and to include manual casts in all kinds of places. fbwb -
MySql returns integers as strings - how to return as integers?
fbwb replied to fbwb's topic in MySQL Help
Thanks, but I don't want to cast every column manually, I just want to keep the types set in MySQL. So I want PHP to automatically receive integers when the MySQL column type is set to int. Any ideas? -
Hi, I have various tables that contain integer attributes. When I query any integer value, it is returned as a string - at least in PHP it is of type "string". Is it possible to maintain the type, so I receive integer values in PHP when querying an integer column? Thanks in advance, Steffen