Re: BUG #6277: Money datatype conversion wrong with Russian locale - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6277: Money datatype conversion wrong with Russian locale
Date
Msg-id 16309.1319905035@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6277: Money datatype conversion wrong with Russian locale  ("Alexander LAW" <exclusion@gmail.com>)
Responses Re: BUG #6277: Money datatype conversion wrong with Russian locale  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-bugs
"Alexander LAW" <exclusion@gmail.com> writes:
> It's caused by wrong mon_thousands_sep processing in
> backend/utils/adt/cash.c, cash_out function.
> The code assumes that the thousands separator fits in one character. But in
> Russian locale we have non-breakable space as the thousands separator (0xC2
> 0xA0 in UTF-8).

Hmm ... looks like cash_out really needs a significant rewrite to make
that work nicely.  It's combining counting of digit positions with
counting of output bytes, which was messy enough already, but gets
worse fast if the thousands separator isn't a single byte.

Does anyone know of locales where the decimal point isn't a single byte?
I'm wondering if that assumption needs to be got rid of too.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Alexander LAW"
Date:
Subject: BUG #6277: Money datatype conversion wrong with Russian locale
Next
From: Alexander Lakhin
Date:
Subject: Re: BUG #6277: Money datatype conversion wrong with Russian locale