Re: unexpected character used as group separator by to_char

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

In response to

Responses

Browse pgsql-general by date

  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