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');