From: | "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | locale issues with float |
Date: | 2002-10-25 13:32:01 |
Message-ID: | 3DB947D1.7040001@sonalysts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I believe the issue with misparsing of floats/doubles/etc has
been correctly identified as a locale issue and *incorrectly*
identified as a carriage-return/linefeed issue.
Somewhere I thought I saw Bruce say that it's already fixed...
From 7.3b2, psql as started:
rovero=# show lc_numeric
rovero-# ;
lc_numeric
-------------
en_US.UTF-8
Copy of floats in "236.555" format will fail.
Copy of floats in "236,555" format works.....
rovero=# set lc_numeric='C';
SET
rovero=# show lc_numeric;
lc_numeric
------------
C
Copy of floats in "235.555" format works.....
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2002-10-25 13:53:19 | lpad question |
Previous Message | Stephan Szabo | 2002-10-25 12:55:30 | Re: new error on compiling |