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