From: | "Gavan Schneider" <list(dot)pg(dot)gavan(at)pendari(dot)org> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "Vincent Veyron" <vv(dot)lists(at)wanadoo(dot)fr>, pgsql-general <pgsql-general(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: unexpected character used as group separator by to_char |
Date: | 2021-03-10 09:38:59 |
Message-ID: | C15D4E93-9922-401D-9EFB-DDE0610D0498@pendari.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10 Mar 2021, at 16:24, Alvaro Herrera wrote:
> That space (0xe280af) is U+202F, which appears to be used for French
> and
> Mongolian languages (exclusively?). It is quite possible that in the
> future some other language will end up using some different whitespace
> character, possibly breaking any code you write today -- the use of
> U+202F appears to be quite recent.
>
Drifting off topic a little. That a proper code point for things that
will benefit from the whitespace but should still stay together.
Also it’s not that new, added in 1999 —
https://codepoints.net/U+202F
The other use case is between the number and its ISO symbol e.g.,
20 °C — and the non-breaking form is important here
As for who uses a thin space in money… it is a normal in European
notation — https://www.languageediting.com/format-numbers-eu-vs-us/
And the thin space is part of the international standard for breaking up
large numbers (from 1948), specifically no dots or commas should be used
in this role. The dot or comma is only to be used for the decimal point!
All of which just highlights problems in localisation and begs the
question whether there is an ISO locale setting — it should work
everywhere ;)
Gavan Schneider
——
Gavan Schneider, Sodwalls, NSW, Australia
Explanations exist; they have existed for all time; there is always a
well-known solution to every human problem — neat, plausible, and
wrong.
— H. L. Mencken, 1920
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2021-03-10 12:08:12 | How to check for existence of nested JSONB property key? |
Previous Message | Andrus | 2021-03-10 09:10:14 | Re: SV: Log files polluted with permission denied error messages after every 10 seconds |