Edit report at http://bugs.php.net/bug.php?id=46408&edit=1
ID: 46408
Comment by: lewis at peppermind dot de
Reported by: alec at smecher dot bc dot ca
Summary: Locale number format settings can cause
pg_query_params to break with numerics
Status: Open
Type: Bug
Package: PostgreSQL related
Operating System: *
PHP Version: 5.*, 6
New Comment:
This issue also appears with pg_execute(), when passing float values to
the bind array, with a locale that uses comma as decimal separator (such
as de_DE and most other european locales).
Previous Comments:
------------------------------------------------------------------------
[2009-07-26 18:59:12] jerico dot dev at gmail dot com
@jani: When I pass in a double, I expect pg_query_params() to prepare it
in a way that can be understood by the database independent of my locale
settings. AFAIK the implementation of pg_query_params() is also
inconsistent with that of the mysql driver which correctly accepts
double typed parameters independent of locale.
I guess you were not entirely serious when you proposed that one should
switch the locale before using pg_query_params(), were you?
------------------------------------------------------------------------
[2008-11-21 13:09:19] [email protected]
I guess it's an issue always if extension does 'convert_to_string()'.
Easily avoided in code: Only do setlocale() prior to outputting stuff.
And then restore the locale right after output. :)
------------------------------------------------------------------------
[2008-11-18 23:16:44] alec at smecher dot bc dot ca
Thanks, lsmith and RhodiumToad. FYI, this bug also exists in PDO (I can
post reproduce code if it's helpful).
------------------------------------------------------------------------
[2008-11-18 22:59:44] [email protected]
<RhodiumToad> lsmith: in a parameterized query it's always wrong to use
locale-specific delimiters
RhodiumToad is also known as Andrew Gierth and is a highly respected
expert on #postgresql on freenode.
As such I will reopen the bug ..
------------------------------------------------------------------------
[2008-10-31 18:28:57] alec at smecher dot bc dot ca
FYI, there's a discussion of the same bug, which also appeared (in a
separate implementation) in the implementation of the Pear::DB package:
<http://pear.php.net/bugs/bug.php?id=3021>
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=46408
--
Edit this bug report at http://bugs.php.net/bug.php?id=46408&edit=1
