From 8902ea4a603da7972622368a5a0ae0894beebf71 Mon Sep 17 00:00:00 2001
From: Paul Ramsey <pramsey@cleverelephant.ca>
Date: Wed, 8 Feb 2012 00:23:11 +0000
Subject: [PATCH] loader/Latin1 regression failure with database SQL_ASCII
 encoding (#1465) from Greg Troxel

git-svn-id: http://svn.osgeo.org/postgis/trunk@9088 b70326c6-7e19-0410-871a-916f4a2858ee
---
 regress/loader/Latin1.select.sql | 1 +
 regress/run_test                 | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/regress/loader/Latin1.select.sql b/regress/loader/Latin1.select.sql
index 663dc296f..b8140ceba 100644
--- a/regress/loader/Latin1.select.sql
+++ b/regress/loader/Latin1.select.sql
@@ -1 +1,2 @@
+SET CLIENT_ENCODING to UTF8;
 SELECT * FROM loadedshp;
diff --git a/regress/run_test b/regress/run_test
index 93f342136..356e1e90d 100755
--- a/regress/run_test
+++ b/regress/run_test
@@ -559,7 +559,7 @@ if test -z "$db_exists"; then
 		# ON_ERROR_STOP is used by psql to return non-0 on an error
 		_psql_opts="--no-psqlrc --variable ON_ERROR_STOP=true"
 
-		createdb --template=template0 --lc-collate="C" "${DB}" > ${TMPDIR}/regress_log
+		createdb --encoding=UTF-8 --template=template0 --lc-collate="C" "${DB}" > ${TMPDIR}/regress_log
 		createlang plpgsql "${DB}" >> ${TMPDIR}/regress_log
 
 		# Count database objects before installing anything
-- 
2.40.0