locale issues with float
| От | P.J. \"Josh\" Rovero |
|---|---|
| Тема | locale issues with float |
| Дата | |
| Msg-id | 3DB947D1.7040001@sonalysts.com обсуждение исходный текст |
| Список | 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@sonalysts.com www.sonalysts.com 215 Parkway North Work: (860)326-3671 or 442-4355 Waterford CT 06385 ***********************************************************************
В списке pgsql-general по дате отправления: