Ensure that strap catalog uses UTF-8 for database reads and writes (GH …

…#95). This change only applies to MySQL and PostgreSQL databases.
interchange · May 2, 2016 · 5c014d9 · 5c014d9
1 parent 1272271
commit 5c014d9
Show file tree

Hide file tree

Showing 2 changed files with 6 additions and 0 deletions.
diff --git 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
@@ -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