changeset 215:680a6eeaa0a6 puppet-3.6

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
author IBBoard <dev@ibboard.co.uk>
date Thu, 01 Aug 2019 20:26:58 +0100
parents 0139629a5023
children 436be6e59198
files modules/website/manifests/mysql.pp
diffstat 1 files changed, 3 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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',