|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull Requests
Pull requests:
HistoryAllCommentsChangesGit/SVN commits
[2021-02-04 13:47 UTC] cmb@php.net
-Status: Open
+Status: Verified
-Assigned To:
+Assigned To: cmb
[2021-02-04 13:54 UTC] cmb@php.net
[2021-02-05 12:13 UTC] cmb@php.net
[2021-02-05 12:13 UTC] cmb@php.net
-Status: Verified
+Status: Closed
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 15:00:01 2025 UTC |
Description: ------------ When retrieving spatial coordinates from a point column using the x() and y() sql functions, the mysqli fetch_array(MYSQLI_ASSOC) method return integers instead of floats if using the MYSQLI_OPT_INT_AND_FLOAT_NATIVE option and locale that don't have a fullstop as decimal separator. Test script: --------------- setlocale(LC_ALL, "de_DE.UTF-8"); $m = new mysqli(); $m->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, true); $result = $m->query("SELECT Y(Point(56.7, 53.34))"); var_dump($result->fetch_array(MYSQLI_ASSOC)); Expected result: ---------------- array(1) { 'Y(Point(56.7, 53.34))' => double(53.34) } Actual result: -------------- array(1) { 'Y(Point(56.7, 53.34))' => double(53) }