diff options
author | Arthur Schiwon <blizzz@arthur-schiwon.de> | 2021-08-31 22:01:27 +0300 |
---|---|---|
committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2021-09-09 20:41:48 +0300 |
commit | f353dd98f440310893fd2fae7791de4f31588ea8 (patch) | |
tree | 9519cef7a8e26770f29fb862daebe1b1175e532c /config/config.sample.php | |
parent | 0d8a36aebf5acc06cb132cfc92324ad3f8d2ed1a (diff) |
make it possible to override the default collation
- allows admins to configure it for edge cases like accent sensitivity
Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>
Diffstat (limited to 'config/config.sample.php')
-rw-r--r-- | config/config.sample.php | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/config/config.sample.php b/config/config.sample.php index 4fcfc5fb6fd..e15afe48dc8 100644 --- a/config/config.sample.php +++ b/config/config.sample.php @@ -1544,6 +1544,24 @@ $CONFIG = [ 'mysql.utf8mb4' => false, /** + * For search queries in the database, a default collation – depending on the + * character set – is chosen. In some cases a different behaviour is desired, + * for instances when a accent sensitive search is desired. + * + * MariaDB and MySQL have an overlap in available collations, but also + * incompatible ones, also depending on the version of the database server. + * + * This option allows to override the automatic choice. Example: + * + * 'mysql.collation' => 'utf8mb4_0900_as_ci', + * + * This setting has no effect on setup or creating tables. In those cases + * always utf8[mb4]_bin is being used. This setting is only taken into + * consideration in SQL queries that utilize LIKE comparison operators. + */ +'mysql.collation' => null, + +/** * Database types that are supported for installation. * * Available: |