icu_ext

pig build pkg icu_ext;		# build rpm

pig repo add pgsql -u   # add both repo and update cache

pig install icu_ext;		# install via package name, for the active PG version

pig install icu_ext -v 18;   # install for PG 18
pig install icu_ext -v 17;   # install for PG 17
pig install icu_ext -v 16;   # install for PG 16
pig install icu_ext -v 15;   # install for PG 15
pig install icu_ext -v 14;   # install for PG 14

CREATE EXTENSION icu_ext;

SELECT icu_version();           -- ICU library version
SELECT icu_unicode_version();   -- Unicode standard version

SELECT * FROM icu_locales_list() WHERE name LIKE 'es%' LIMIT 5;
SELECT icu_default_locale();
SELECT icu_set_default_locale('en');

SELECT * FROM icu_collation_attributes('fr-u-ks-level2-kn');

-- Case-sensitive, accent-insensitive comparison:
SELECT icu_compare('abce', 'abce', 'en-u-ks-level1-kc-true');  -- 0
SELECT icu_compare('Abce', 'abce', 'en-u-ks-level1-kc-true');  -- 1

CREATE UNIQUE INDEX idx ON my_table((icu_sort_key(name, 'fr-u-ks-level1')));

SELECT * FROM icu_character_boundaries('Hello', 'en');
SELECT * FROM icu_word_boundaries('I like books', 'en');
SELECT * FROM icu_sentence_boundaries('Mr. Smith went home. He was tired.', 'en');
SELECT * FROM icu_line_boundaries('Long text here', 'en');

SELECT icu_normalize('text', 'NFC');
SELECT icu_is_normalized('text', 'NFC');
SELECT icu_transform('Hello', 'Latin-Cyrillic');
SELECT * FROM icu_transforms_list();

SELECT icu_number_spellout(42, 'en');   -- 'forty-two'
SELECT icu_number_spellout(42, 'fr');   -- 'quarante-deux'

SELECT icu_spoof_check('paypal');
SELECT icu_confusable_strings_check('google', 'gооgle');

SELECT icu_char_name('A');
SELECT icu_char_type('A');