| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | rjuju123(at)gmail(dot)com |
| Subject: | link that explain ICU_LOCALE locale concept about local variant code and keywords. |
| Date: | 2022-05-25 08:22:21 |
| Message-ID: | CACJufxH8LRBRj0aMp7kh6sxro4qfeMRZnQafFau5jPQF0+uXpw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
code from
https://www.postgresql.org/message-id/flat/5e756dd6-0e91-d778-96fd-b1bcb06c161a%402ndquadrant.com
> DROP DATABASE IF EXISTS dbicu;
> CREATE DATABASE dbicu LOCALE_PROVIDER icu LOCALE 'en_US' ICU_LOCALE
> 'en-u-kf-upper' template 'template0';
> \c dbicu
> CREATE COLLATION upperfirst (provider = icu, locale = 'en-u-kf-upper');
> CREATE TABLE icu(def text, en text COLLATE "en_US", upfirst text COLLATE
> upperfirst);
> INSERT INTO icu VALUES ('a', 'a', 'a'), ('b','b','b'), ('A','A','A'),
> ('B','B','B');
> SELECT def AS def FROM icu ORDER BY def;
> SELECT def AS en FROM icu ORDER BY en;
> SELECT def AS upfirst FROM icu ORDER BY upfirst;
> SELECT def AS upfirst_explicit FROM icu ORDER BY en COLLATE upperfirst;
> SELECT def AS en_x_explicit FROM icu ORDER BY def COLLATE "en-x-icu";
>
- trying to replicate the above quoted command.
- So I don't know * ICU_LOCALE 'en-u-kf-upper' *the *u *and the *kf *refer
to?
Even I followed
https://unicode-org.github.io/icu/userguide/locale/#the-locale-concept
1. Language code
2. Script code
3. Country code
4. Variant code
5. Keywords
So which website can I get the info about the "kf" and "u".
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abhishek Bhola | 2022-05-25 08:32:30 | PG 13.6 : Data corruption error message not being sent to syslog |
| Previous Message | jian he | 2022-05-25 07:19:11 | Re: cast to domain with default collation issue. |