# PostgreSQL pg_query_params, PHP locales, and double data types

- Thread: https://externals.io/message/41979
- Original archive: https://news-web.php.net/php.internals/41979
- Started by Alec Smecher on 2008-11-17T16:54:48+00:00
- Messages: 4
- Reply by email to internals@lists.php.net
- More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt

---

## #41979 — Alec Smecher — 2008-11-17T16:54:48+00:00

URL: https://externals.io/message/41979#41979

Hi all,

I'm trying to get a PHP bug in the PostgreSQL pg_query_params function 
reopened; it's been marked bogus (incorrectly IMO). There are lots of 
details at <http://bugs.php.net/bug.php?id=46408>. If this is in fact 
bogus, I'd appreciate a little bit of feedback.

Many thanks!
Alec Smecher
Public Knowledge Project Team

---

## #41985 — Lukas Kahwe Smith — 2008-11-18T15:54:06+00:00

URL: https://externals.io/message/41979#41985 · In reply to: #41979

> I'm trying to get a PHP bug in the PostgreSQL pg_query_params  
> function reopened; it's been marked bogus (incorrectly IMO). There  
> are lots of details at <http://bugs.php.net/bug.php?id=46408>. If  
> this is in fact bogus, I'd appreciate a little bit of feedback.


Just out of curiosity, did you test this with PDO?
Personally I always found the entire `setlocale()` business entirely  
painful.

regards,
Lukas Kahwe Smith
mls@pooteeweet.org

---

## #41986 — Alec Smecher — 2008-11-18T16:04:22+00:00

URL: https://externals.io/message/41979#41986 · In reply to: #41985

Lukas Kahwe Smith wrote:
> 
> > […]
> Just out of curiosity, did you test this with PDO?
> Personally I always found the entire `setlocale()` business entirely 
> painful.
No, I haven't tried PDO; my application requires PHP 4.x compatibility 
for the time being, unfortunately, and PDO is 5.x-only.

---

## #41989 — Alec Smecher — 2008-11-18T22:08:42+00:00

URL: https://externals.io/message/41979#41989 · In reply to: #41986

Alec Smecher wrote:
> Lukas Kahwe Smith wrote:
> > […]
> No, I haven't tried PDO; my application requires PHP 4.x compatibility 
> for the time being, unfortunately, and PDO is 5.x-only.
BTW, after a little follow-up conversation with Lukas (thanks), I've 
also confirmed that PDO has the same problem. Both PostgreSQL's number 
parser and the SQL-92 spec expect numbers to be formatted with a "." for 
the decimal place.

Regards,
Alec Smecher