/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/fuzzystrmatch/sql/fuzzystrmatch_utf8.sql
26 строк
683 B
Tom Lane
Add support for Daitch-Mokotoff Soundex in contrib/fuzzystrmatch.
08 апр 2023, 00:32
08 апр 2023, 00:32
a290378
Код
Авторство
О чём код?
/* * This test must be run in a database with UTF-8 encoding, * because other encodings don't support all the characters used. */ SELECT getdatabaseencoding() <> 'UTF8' AS skip_test \gset \if :skip_test \quit \endif set client_encoding = utf8; -- CREATE EXTENSION IF NOT EXISTS fuzzystrmatch; -- Accents SELECT daitch_mokotoff('Müller'); SELECT daitch_mokotoff('Schäfer'); SELECT daitch_mokotoff('Straßburg'); SELECT daitch_mokotoff('Éregon'); -- Special characters added at https://www.jewishgen.org/InfoFiles/Soundex.html SELECT daitch_mokotoff('gąszczu'); SELECT daitch_mokotoff('brzęczy'); SELECT daitch_mokotoff('ţamas'); SELECT daitch_mokotoff('țamas');