aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter@eisentraut.org>2019-01-02 18:36:05 +0100
committerPeter Eisentraut <peter@eisentraut.org>2019-01-02 18:36:05 +0100
commitb6f3649bba9832cf4958dbb184dabef93dcea29c (patch)
tree8c54233d1194753a94aa84a06091156cf4d26b57
parent1707a0d2aa6b2bcfe78f63836c769943a1a6b9e0 (diff)
downloadpostgresql-b6f3649bba9832cf4958dbb184dabef93dcea29c.tar.gz
postgresql-b6f3649bba9832cf4958dbb184dabef93dcea29c.zip
Convert unaccent tests to UTF-8
This makes it easier to add new tests that are specific to Unicode features. The files were previously in KOI8-R. Discussion: https://www.postgresql.org/message-id/8506.1545111362@sss.pgh.pa.us
-rw-r--r--contrib/unaccent/expected/unaccent.out26
-rw-r--r--contrib/unaccent/sql/unaccent.sql14
2 files changed, 20 insertions, 20 deletions
diff --git a/contrib/unaccent/expected/unaccent.out b/contrib/unaccent/expected/unaccent.out
index b93105e9c7c..0835e141afb 100644
--- a/contrib/unaccent/expected/unaccent.out
+++ b/contrib/unaccent/expected/unaccent.out
@@ -6,23 +6,23 @@ SELECT getdatabaseencoding();
UTF8
(1 row)
-SET client_encoding TO 'KOI8';
+SET client_encoding TO 'UTF8';
SELECT unaccent('foobar');
unaccent
----------
foobar
(1 row)
-SELECT unaccent('£ΜΛΑ');
+SELECT unaccent('Ρ‘Π»ΠΊΠ°');
unaccent
----------
- ΕΜΛΑ
+ Π΅Π»ΠΊΠ°
(1 row)
-SELECT unaccent('³φιλ');
+SELECT unaccent('ΠΠ–Π˜Πš');
unaccent
----------
- εφιλ
+ Π•Π–Π˜Πš
(1 row)
SELECT unaccent('unaccent', 'foobar');
@@ -31,16 +31,16 @@ SELECT unaccent('unaccent', 'foobar');
foobar
(1 row)
-SELECT unaccent('unaccent', '£ΜΛΑ');
+SELECT unaccent('unaccent', 'Ρ‘Π»ΠΊΠ°');
unaccent
----------
- ΕΜΛΑ
+ Π΅Π»ΠΊΠ°
(1 row)
-SELECT unaccent('unaccent', '³φιλ');
+SELECT unaccent('unaccent', 'ΠΠ–Π˜Πš');
unaccent
----------
- εφιλ
+ Π•Π–Π˜Πš
(1 row)
SELECT ts_lexize('unaccent', 'foobar');
@@ -49,15 +49,15 @@ SELECT ts_lexize('unaccent', 'foobar');
(1 row)
-SELECT ts_lexize('unaccent', '£ΜΛΑ');
+SELECT ts_lexize('unaccent', 'Ρ‘Π»ΠΊΠ°');
ts_lexize
-----------
- {ΕΜΛΑ}
+ {Π΅Π»ΠΊΠ°}
(1 row)
-SELECT ts_lexize('unaccent', '³φιλ');
+SELECT ts_lexize('unaccent', 'ΠΠ–Π˜Πš');
ts_lexize
-----------
- {εφιλ}
+ {Π•Π–Π˜Πš}
(1 row)
diff --git a/contrib/unaccent/sql/unaccent.sql b/contrib/unaccent/sql/unaccent.sql
index 310213994f3..ba72ab6261c 100644
--- a/contrib/unaccent/sql/unaccent.sql
+++ b/contrib/unaccent/sql/unaccent.sql
@@ -3,16 +3,16 @@ CREATE EXTENSION unaccent;
-- must have a UTF8 database
SELECT getdatabaseencoding();
-SET client_encoding TO 'KOI8';
+SET client_encoding TO 'UTF8';
SELECT unaccent('foobar');
-SELECT unaccent('£ΜΛΑ');
-SELECT unaccent('³φιλ');
+SELECT unaccent('Ρ‘Π»ΠΊΠ°');
+SELECT unaccent('ΠΠ–Π˜Πš');
SELECT unaccent('unaccent', 'foobar');
-SELECT unaccent('unaccent', '£ΜΛΑ');
-SELECT unaccent('unaccent', '³φιλ');
+SELECT unaccent('unaccent', 'Ρ‘Π»ΠΊΠ°');
+SELECT unaccent('unaccent', 'ΠΠ–Π˜Πš');
SELECT ts_lexize('unaccent', 'foobar');
-SELECT ts_lexize('unaccent', '£ΜΛΑ');
-SELECT ts_lexize('unaccent', '³φιλ');
+SELECT ts_lexize('unaccent', 'Ρ‘Π»ΠΊΠ°');
+SELECT ts_lexize('unaccent', 'ΠΠ–Π˜Πš');