From c18b1aea289e8ed6edb3f6e6a135018976a034c6 Mon Sep 17 00:00:00 2001 From: Nikita Popov Date: Tue, 15 Dec 2020 17:07:27 +0100 Subject: PDO MySQL: Use native types for results Previously, PDO MySQL only fetched data as native int/float if native prepared statements were used. This patch updates PDO to have the same behavior for emulated prepared statements, and thus removes the largest remaining discrepancy between these two modes. Note that PDO already has a ATTR_STRINGIFY_FETCHES option to control whether native types are desired or not. The previous output can be restored by enabling this option. Most of the tests make use of that option, because this allows the tests to work under libmysqlclient as well, which currently always returns string results (independently of whether native or emulated PS are used). --- UPGRADING | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'UPGRADING') diff --git a/UPGRADING b/UPGRADING index 7f530497e7..d2aaa08ac5 100644 --- a/UPGRADING +++ b/UPGRADING @@ -31,6 +31,12 @@ PHP 8.1 UPGRADE NOTES . The mysqlnd.fetch_copy_data ini setting has been removed. However, this should not result in user-visible behavior changes. +- PDO MySQL: + . Integers and floats in result sets will now be returned using native PHP + types instead of strings when using emulated prepared statements. This + matches the behavior of native prepared statements. You can restore the + previous behavior by enabling the PDO::ATTR_STRINGIFY_FETCHES option. + - Standard: . version_compare() no longer accepts undocumented operator abbreviations. -- cgit v1.2.1