 | |
OCI8: Numbers fetched as strings
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
OCI8: Numbers fetched as strings -
09-11-2008
, 11:58 AM
#2
| |||
| |||
|
|
I'm playing with PHP and its oci8 extension and I'm facing a curious issue: numeric fields are returned as strings and, to make it worse, they're formatted using locale settings (well, sort of). For instance: 1234.56 ---> "1234,56" According to the documentation I've read, it isn't a bug: it's intentional. The "Underground PHP and Oracle Manual" describes the problem but it doesn't suggest any solution. Am I supposed to write a custom parser to convert numeric strings into floats and pray that the DBA will never change the locale settings? Is it enough to run... alter session set nls_territory=america nls_language=american ... when I open the (persistent) connection? (I still get strings but at least they're easy to cast.) |
the decimal comma character.
Yours,
Laurenz Albe
#3
| |||
| |||
|
|
I'm playing with PHP and its oci8 extension and I'm facing a curious issue: numeric fields are returned as strings and, to make it worse, they're formatted using locale settings (well, sort of). For instance: 1234.56 ---> "1234,56" According to the documentation I've read, it isn't a bug: it's intentional. The "Underground PHP and Oracle Manual" describes the problem but it doesn't suggest any solution. Am I supposed to write a custom parser to convert numeric strings into floats and pray that the DBA will never change the locale settings? Is it enough to run... alter session set nls_territory=america nls_language=american ... when I open the (persistent) connection? (I still get strings but at least they're easy to cast.) |
the decimal comma character.
Yours,
Laurenz Albe
#4
| |||
| |||
|
|
I'm playing with PHP and its oci8 extension and I'm facing a curious issue: numeric fields are returned as strings and, to make it worse, they're formatted using locale settings (well, sort of). For instance: 1234.56 ---> "1234,56" According to the documentation I've read, it isn't a bug: it's intentional. The "Underground PHP and Oracle Manual" describes the problem but it doesn't suggest any solution. Am I supposed to write a custom parser to convert numeric strings into floats and pray that the DBA will never change the locale settings? Is it enough to run... alter session set nls_territory=america nls_language=american ... when I open the (persistent) connection? (I still get strings but at least they're easy to cast.) |
the decimal comma character.
Yours,
Laurenz Albe
#5
| |||
| |||
|
|
I'm playing with PHP and its oci8 extension and I'm facing a curious issue: numeric fields are returned as strings and, to make it worse, they're formatted using locale settings (well, sort of). For instance: 1234.56 ---> "1234,56" According to the documentation I've read, it isn't a bug: it's intentional. The "Underground PHP and Oracle Manual" describes the problem but it doesn't suggest any solution. Am I supposed to write a custom parser to convert numeric strings into floats and pray that the DBA will never change the locale settings? Is it enough to run... alter session set nls_territory=america nls_language=american ... when I open the (persistent) connection? (I still get strings but at least they're easy to cast.) |
the decimal comma character.
Yours,
Laurenz Albe
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.