From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Daniel Verite <daniel(at)manitou-mail(dot)org>, iksss(dot)88(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter |
Date: | 2019-05-15 19:43:51 |
Message-ID: | 4F264E45-7708-4CCF-81BE-CE5AF190E71F@yesql.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> On 15 May 2019, at 17:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Daniel Verite" <daniel(at)manitou-mail(dot)org> writes:
>> PG Bug reporting form wrote:
>>> lower('ΔΗΜΟΤΕΣ ΦΑΙΣΤΟΥ') =
>>> "δημοτεσ φαιστου" instead of "δημοτες φαιστου"
>
>> With PostgreSQL version 10 or newer, you could use an ICU
>> locale. lower() would produce the expected result:
>
> Oh, if using ICU already fixes this, I think we might as well just
> say that you have to use ICU if you want the right behavior for such
> cases.
Seems reasonable. Maybe it warrants a mention in the docs on the string
function page since it may suprise users?
cheers ./daniel
Attachment | Content-Type | Size |
---|---|---|
casefolding.diff | application/octet-stream | 542 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2019-05-15 23:53:18 | Re: inconsistent results querying table partitioned by date |
Previous Message | Richard Yen | 2019-05-15 18:44:06 | Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names |