1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
|
/*
* 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');
daitch_mokotoff
-----------------
{689000}
(1 row)
SELECT daitch_mokotoff('Schäfer');
daitch_mokotoff
-----------------
{479000}
(1 row)
SELECT daitch_mokotoff('Straßburg');
daitch_mokotoff
-----------------
{294795}
(1 row)
SELECT daitch_mokotoff('Éregon');
daitch_mokotoff
-----------------
{095600}
(1 row)
-- Special characters added at https://www.jewishgen.org/InfoFiles/Soundex.html
SELECT daitch_mokotoff('gąszczu');
daitch_mokotoff
-----------------
{564000,540000}
(1 row)
SELECT daitch_mokotoff('brzęczy');
daitch_mokotoff
-------------------------------
{794640,794400,746400,744000}
(1 row)
SELECT daitch_mokotoff('ţamas');
daitch_mokotoff
-----------------
{364000,464000}
(1 row)
SELECT daitch_mokotoff('țamas');
daitch_mokotoff
-----------------
{364000,464000}
(1 row)
|