# HG changeset patch
# User Michael Schloh von Bennewitz <michael@schloh.com>
# Date 1290436056 -3600
# Node ID e2eb036d448fe6c2b6fec53e7598b29a68f5f866
# Parent  41f699c33d5fc3510fd1bcd227ce78e6d8becc42
Resolve a conflicting database encoding error.
The error states: 'new encoding (UTF8) is incompatible
with the encoding of the template database (SQL_ASCII).'

diff -r 41f699c33d5f -r e2eb036d448f davical/davical-setup.sh
--- a/davical/davical-setup.sh	Mon Nov 22 14:44:13 2010 +0100
+++ b/davical/davical-setup.sh	Mon Nov 22 15:27:36 2010 +0100
@@ -40,7 +40,7 @@
         #   create database
         ( echo "CREATE ROLE $db_user LOGIN ENCRYPTED PASSWORD '$db_pass' NOCREATEDB NOCREATEUSER;"
           echo "CREATE TABLESPACE $db_name OWNER $db_user LOCATION '$db_dir';"
-          echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE $db_name ENCODING 'UTF8';"
+          echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE $db_name ENCODING 'SQL_ASCII';"
         ) | PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_sname" -f-
         PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" \
             -c "CREATE LANGUAGE plpgsql;"