This is an automated email from the ASF dual-hosted git repository.
ilgrosso pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/syncope.git
The following commit(s) were added to refs/heads/master by this push:
new 65343231b4 [SYNCOPE-1812] Instructions about configuring MariaDB for
case-sensitive queries (#673)
65343231b4 is described below
commit 65343231b46a773013bb73fb1077037d17bc3c62
Author: Samuel Garofalo <[email protected]>
AuthorDate: Fri Apr 5 08:29:49 2024 +0200
[SYNCOPE-1812] Instructions about configuring MariaDB for case-sensitive
queries (#673)
---
src/main/asciidoc/reference-guide/configuration/dbms.adoc | 11 +++++++++++
1 file changed, 11 insertions(+)
diff --git a/src/main/asciidoc/reference-guide/configuration/dbms.adoc
b/src/main/asciidoc/reference-guide/configuration/dbms.adoc
index 2a52c98b3a..b6cb404fca 100644
--- a/src/main/asciidoc/reference-guide/configuration/dbms.adoc
+++ b/src/main/asciidoc/reference-guide/configuration/dbms.adoc
@@ -209,6 +209,17 @@ for the Core application.
[CAUTION]
It is important to set the collation to `utf8_general_ci` after creation of
`syncope` database.
+[WARNING]
+====
+It is necessary to use `utf8mb4_unicode_ci` instead of `utf8mb4_general_ci` if
case-sensitive queries are required.
+In this case, set
+....
+init_connect = "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
+....
+under either the `[mysqld]` section or the `[mariadb]` section of your
+https://mariadb.com/kb/en/configuring-mariadb-with-option-files/[option file^].
+====
+
[WARNING]
This assumes that you have a MariaDB instance running on localhost, listening
on its default port 3306 with a database
`syncope` fully accessible by user `syncope` with password `syncope`.
