Thread: BUG #9793: to_number wrong convertion
The following bug has been logged on the website:
Bug reference: 9793
Logged by: George
Email address: info@gevnet.nl
PostgreSQL version: 9.3.1
Operating system: Windows 7
Description:
Hi,
My local is NL, so decimal separator is ',' whene i am calling
to_number('123,45','999999D99') i am getting 12345 insted of 123.45 in de
numeric filend in the database.
In 9.2 is working correctly and in 9.3 no mo more.
Thanks,
George
info@gevnet.nl writes:
> My local is NL, so decimal separator is ',' whene i am calling
> to_number('123,45','999999D99') i am getting 12345 insted of 123.45 in de
> numeric filend in the database.
> In 9.2 is working correctly and in 9.3 no mo more.
AFAIK the behavior of that case didn't change in 9.3. Are you sure you
have the locale settings of your database (particularly lc_numeric) the
same as you had in 9.2?
regards, tom lane
"GEV.NET" <info@gevnet.nl> writes:
> I am installing with the default settings so it is automatically local
> settings right ?
Well, that's unproven. Did you actually do "show lc_numeric" on either
server?
regards, tom lane
I am installing with the default settings so it is automatically local
settings right ?
On 1 PC it is 9.2 and its working fine but on the other PC it is 9.3 and =
it
is not working. Both are installed with default settings and both PC =
have a
locale NL.
Met vriendelijke groet,
George
Business =
Park=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=20
Lijndonk 4=A0=A0 Unit 1.19=A0=A0=A0=A0=A0=A0=A0=A0=20
4825 BG Breda=A0=A0=A0=A0=A0=A0=20
[M]: 06-20626078=A0=A0=A0=A0=A0=A0=A0 [T]:=A0 0767370228=A0=A0=A0=A0=A0 =
=A0
[w]: www.rkassa.nl=A0=A0=A0=A0=A0=A0 [E]:=A0 info@rkassa.nl
-----Oorspronkelijk bericht-----
Van: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Verzonden: maandag 31 maart 2014 17:15
Aan: info@gevnet.nl
CC: pgsql-bugs@postgresql.org
Onderwerp: Re: [BUGS] BUG #9793: to_number wrong convertion
info@gevnet.nl writes:
> My local is NL, so decimal separator is ',' whene i am calling
> to_number('123,45','999999D99') i am getting 12345 insted of 123.45=20
> in de numeric filend in the database.
> In 9.2 is working correctly and in 9.3 no mo more.
AFAIK the behavior of that case didn't change in 9.3. Are you sure you =
have
the locale settings of your database (particularly lc_numeric) the same =
as
you had in 9.2?
regards, tom lane
-----
Geen virus gevonden in dit bericht.
Gecontroleerd door AVG - www.avg.com
Versie: 2014.0.4354 / Virusdatabase: 3722/7273 - datum van uitgifte:
03/30/14