aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--contrib/unaccent/expected/unaccent.out7
-rw-r--r--contrib/unaccent/sql/unaccent.sql3
2 files changed, 10 insertions, 0 deletions
diff --git a/contrib/unaccent/expected/unaccent.out b/contrib/unaccent/expected/unaccent.out
index 8d197c50be7..a09e00fe5b1 100644
--- a/contrib/unaccent/expected/unaccent.out
+++ b/contrib/unaccent/expected/unaccent.out
@@ -1,6 +1,13 @@
SET client_min_messages = warning;
\set ECHO none
RESET client_min_messages;
+-- must have a UTF8 database
+SELECT getdatabaseencoding();
+ getdatabaseencoding
+---------------------
+ UTF8
+(1 row)
+
SET client_encoding TO 'KOI8';
SELECT unaccent('foobar');
unaccent
diff --git a/contrib/unaccent/sql/unaccent.sql b/contrib/unaccent/sql/unaccent.sql
index 71ab5bb4358..ede938d4795 100644
--- a/contrib/unaccent/sql/unaccent.sql
+++ b/contrib/unaccent/sql/unaccent.sql
@@ -4,6 +4,9 @@ SET client_min_messages = warning;
\set ECHO all
RESET client_min_messages;
+-- must have a UTF8 database
+SELECT getdatabaseencoding();
+
SET client_encoding TO 'KOI8';
SELECT unaccent('foobar');