|   | 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 Group All rights reserved. | Last updated: Fri Oct 31 02:00:02 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) }