[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