link that explain ICU_LOCALE locale concept about local variant code and keywords.

Поиск
Список
Период
Сортировка
От jian he
Тема link that explain ICU_LOCALE locale concept about local variant code and keywords.
Дата
Msg-id CACJufxH8LRBRj0aMp7kh6sxro4qfeMRZnQafFau5jPQF0+uXpw@mail.gmail.com
обсуждение исходный текст
Ответы Re: link that explain ICU_LOCALE locale concept about local variant code and keywords.  ("Daniel Verite" <daniel@manitou-mail.org>)
Re: link that explain ICU_LOCALE locale concept about local variant code and keywords.  (jian he <jian.universality@gmail.com>)
Список pgsql-general

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


В списке pgsql-general по дате отправления:

Предыдущее
От: jian he
Дата:
Сообщение: Re: cast to domain with default collation issue.
Следующее
От: Abhishek Bhola
Дата:
Сообщение: PG 13.6 : Data corruption error message not being sent to syslog