[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