From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
---|---|
To: | Daniel Verite <daniel(at)manitou-mail(dot)org> |
Cc: | Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: insensitive collations |
Date: | 2019-03-11 20:36:39 |
Message-ID: | 784c7289-e7c2-d06f-a4a0-bf98aebd5577@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2019-03-08 11:09, Peter Eisentraut wrote:
> On 2019-03-07 20:04, Daniel Verite wrote:
>> With previous versions, we'd need to call ucol_setAttribute(),
>> with the attributes and values defined here:
>> http://icu-project.org/apiref/icu4c/ucol_8h.html
>> for instance to get colStrength=secondary:
>> ucol_setAttribute(coll, UCOL_STRENGTH , UCOL_SECONDARY, &status);
>> which I've just checked gives the expected result with ICU-4.2.
>
> I see. I'm thinking about adding some ad hoc code to
> pg_newlocale_from_collation() to parse these keywords ourselves, so we
> can provide the same interface for old ICU versions. I'll send a
> separate patch for that.
Patches here. This will allow all the existing collation customization
options as well as the ones being proposed in this thread to work in
older ICU versions.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment | Content-Type | Size |
---|---|---|
0001-Add-tests-for-ICU-collation-customization.patch | text/plain | 3.9 KB |
0002-Add-support-for-collation-attributes-on-older-ICU-ve.patch | text/plain | 4.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Regina Obe | 2019-03-11 20:38:56 | Re: Compressed TOAST Slicing |
Previous Message | Karl O. Pinc | 2019-03-11 20:32:14 | Re: Patch to document base64 encoding |