Mercurial > repos > other > Puppet
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',