# HG changeset patch
# User IBBoard <dev@ibboard.co.uk>
# Date 1564687618 -3600
# Node ID 680a6eeaa0a6157df35a5e496557e42e17f3ac29
# Parent  0139629a5023247f0e4b19e18e943e55c0855138
Make database connections default to UTF-8

Prior to this, "…" was stored correctly but served as the Unicode
replacement character � because the DB was UTF-8, the output was
UTF-8 but the mysql connection was defaulting to latin1

diff -r 0139629a5023 -r 680a6eeaa0a6 modules/website/manifests/mysql.pp
--- a/modules/website/manifests/mysql.pp	Sat Jul 27 15:28:16 2019 +0100
+++ b/modules/website/manifests/mysql.pp	Thu Aug 01 20:26:58 2019 +0100
@@ -24,6 +24,9 @@
         'max_heap_table_size' => '64M',
         'table_open_cache' => '64',
         'log-queries-not-using-indexes' => '1',
+        # Set a sensible default character set
+        'character-set-server' => 'utf8',
+        'collation-server' => 'utf8_general_ci',
         # Settings for best MySQL 4-byte Unicode support
         'innodb_large_prefix' => 'true',
         'innodb_file_format' => 'barracuda',