[interchange] Ensure that strap catalog uses UTF-8 for database reads and writes (GH #95).

Stefan Hornburg <[email protected]> Mon, 02 May 2016 16:31:50 +0000
Newsgroups gmane.comp.web.interchange.cvs
Message-ID <[email protected]>
commit 5c014d91126f946123eb30c1d9663edd7eaa1170
Author: Stefan Hornburg (Racke) <[email protected]>
Date:   Mon May 2 18:28:52 2016 +0200

    Ensure that strap catalog uses UTF-8 for database reads and writes (GH #95).
    This change only applies to MySQL and PostgreSQL databases.

 dist/strap/dbconf/mysql/mysql.cfg |    3 +++
 dist/strap/dbconf/pgsql/pgsql.cfg |    3 +++
 2 files changed, 6 insertions(+), 0 deletions(-)
---
diff --git a/dist/strap/dbconf/mysql/mysql.cfg b/dist/strap/dbconf/mysql/mysql.cfg
index eb6c510..6b50beb 100644
--- a/dist/strap/dbconf/mysql/mysql.cfg
+++ b/dist/strap/dbconf/mysql/mysql.cfg
@@ -9,6 +9,9 @@ DatabaseDefault PASS __SQLPASS__
 # Default column type
 DatabaseDefault DEFAULT_TYPE varchar(255)
  
+# Use UTF-8 for database reads and writes
+DatabaseDefault MYSQL_ENABLE_UTF8 1
+
 # Include each table definition from its separate file.
 include dbconf/mysql/*.mysql
 
diff --git a/dist/strap/dbconf/pgsql/pgsql.cfg b/dist/strap/dbconf/pgsql/pgsql.cfg
index 9d51113..fb8cba8 100644
--- a/dist/strap/dbconf/pgsql/pgsql.cfg
+++ b/dist/strap/dbconf/pgsql/pgsql.cfg
@@ -6,6 +6,9 @@ Message -i -n Using PostgreSQL, DSN=__SQLDSN__...
 DatabaseDefault USER __SQLUSER__
 DatabaseDefault PASS __SQLPASS__
 
+# Use UTF-8 for database reads and writes
+DatabaseDefault PG_ENABLE_UTF8 1
+
 # Include each table definition from its separate file.
 include dbconf/pgsql/*.pgsql