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

Stefan Hornburg interchange-cvs at icdevgroup.org
Mon May 2 16:31:50 UTC 2016


commit 5c014d91126f946123eb30c1d9663edd7eaa1170
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
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
 



More information about the interchange-cvs mailing list