Correct data type

[mevdschee]

Correct data type

[mevdschee]

There is an easier way (than PDO), you can for instance see how I did this for binary data and nulls. But first, let's analyze the problem:

• string, number, object, array, true, false, null are supported by JSON.
• array, object, true, false are not supported by MySQL.
• decimal, binary, date are not supported by JSON.
• string, number, null are supported by both.
• nulls and strings are handled "correctly".
• PHP implicitly converts strings to numbers when needed.

I'm not saying there can not be a benefit. I think there could be two theoretical benefits in PHP receiving floats and ints (how about decimal type? BC Math?) from MySQL in their corresponding type:

• Avoiding imprecision of string conversion (for floats)
• Performance (no conversion, higher speed)

But do we actually achieve that when we would be receiving floats and ints from PDO? I wonder. Maybe you see other benefits?

[mevdschee]

Maybe we should bypass PHP and output the MySQL string to javascript (JSON) directly. Still I'm worried about javascript's handling of MySQL types.

[mevdschee]

I see no solution for longs and decimals, but a conservative change would be to output small to normal sized integer types without quotes.

[ManniManfred]

In my case it would be ok, because I currently need it only for integers.

[mevdschee]

As you can read here only 53 bits of a 64 bit int are supported. So only 32 bit integers (or smaller) could go without quotes without losing precision.

[mevdschee]

Fixed in 8616b67, but may cause issues on 8 byte integers (>53 bit) as they cannot be represented in JavaScript. See: 1fce372