From 7cb300b82ac380468ba40da4eed0eb35a7420089 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Sat, 2 Dec 2017 18:54:41 +0100 Subject: Fix DB settings for postgres which doesn't use utf8mb4 Signed-off-by: Florian Pritz --- NEWS | 5 +++-- application/config/example/database.php | 4 ++-- 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/NEWS b/NEWS index 96a15b6fb..965a5bd07 100644 --- a/NEWS +++ b/NEWS @@ -8,9 +8,10 @@ This file lists major, incompatible or otherwise important changes, you should l - Changes in application/config/database.php + Change "$active_record = TRUE" to "$query_builder = TRUE" + Change the pconnect setting to FALSE - + Change the char_set setting to "utf8mb4" - + Change the dbcollat setting to "utf8mb4_bin" + Change the stricton setting to TRUE + + If you use mysql: (NOT for postgres installations) + MYSQL Change the char_set setting to "utf8mb4" + MYSQL Change the dbcollat setting to "utf8mb4_bin" - Changes in application/config/config-local.php + Set base_url to your domain and, if used, installation directory. Example: $config['base_url'] = "https://paste.xinu.at/" diff --git a/application/config/example/database.php b/application/config/example/database.php index 6b71bf60b..002faff17 100644 --- a/application/config/example/database.php +++ b/application/config/example/database.php @@ -86,8 +86,8 @@ $db['default'] = array( 'db_debug' => TRUE, 'cache_on' => FALSE, 'cachedir' => '', - 'char_set' => 'utf8mb4', - 'dbcollat' => 'utf8mb4_bin', + 'char_set' => 'utf8mb4', // if you use postgres, set this to utf8 + 'dbcollat' => 'utf8mb4_bin', // if you use postgres, set this to utf8_bin 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, -- cgit v1.2.3-24-g4f1b