(syncope) branch 4_0_X updated: Ensuring case-insensitive queries work with MySQL and MariaDB

[ilgrosso]

This is an automated email from the ASF dual-hosted git repository.

ilgrosso pushed a commit to branch 4_0_X
in repository https://gitbox.apache.org/repos/asf/syncope.git


The following commit(s) were added to refs/heads/4_0_X by this push:
     new c994a05d77 Ensuring case-insensitive queries work with MySQL and 
MariaDB
c994a05d77 is described below

commit c994a05d77555e922459f0c907a22e0dace2184a
Author: Francesco Chicchiriccò <ilgro...@apache.org>
AuthorDate: Fri Sep 19 13:55:30 2025 +0200

    Ensuring case-insensitive queries work with MySQL and MariaDB
---
 docker/src/main/resources/docker-compose/docker-compose-mariadb.yml | 1 +
 docker/src/main/resources/docker-compose/docker-compose-mysql.yml   | 1 +
 fit/core-reference/pom.xml                                          | 3 ++-
 3 files changed, 4 insertions(+), 1 deletion(-)

diff --git 
a/docker/src/main/resources/docker-compose/docker-compose-mariadb.yml 
b/docker/src/main/resources/docker-compose/docker-compose-mariadb.yml
index 037afcef3c..f11b50a13b 100644
--- a/docker/src/main/resources/docker-compose/docker-compose-mariadb.yml
+++ b/docker/src/main/resources/docker-compose/docker-compose-mariadb.yml
@@ -21,6 +21,7 @@ services:
    db:
      image: mariadb:12
      restart: always
+     command: ['--character-set-server=utf8mb4', 
'--collation-server=utf8mb4_bin']
      environment:
        MYSQL_ROOT_PASSWORD: password
        MYSQL_DATABASE: syncope
diff --git a/docker/src/main/resources/docker-compose/docker-compose-mysql.yml 
b/docker/src/main/resources/docker-compose/docker-compose-mysql.yml
index 79e3e82fbf..abb7af7a66 100644
--- a/docker/src/main/resources/docker-compose/docker-compose-mysql.yml
+++ b/docker/src/main/resources/docker-compose/docker-compose-mysql.yml
@@ -21,6 +21,7 @@ services:
    db:
      image: mysql:9.0
      restart: always
+     command: ['--character-set-server=utf8mb4', 
'--collation-server=utf8mb4_bin']
      environment:
        MYSQL_ROOT_PASSWORD: password
        MYSQL_DATABASE: syncope
diff --git a/fit/core-reference/pom.xml b/fit/core-reference/pom.xml
index 375b63ce4b..50d4770937 100644
--- a/fit/core-reference/pom.xml
+++ b/fit/core-reference/pom.xml
@@ -816,7 +816,7 @@ under the License.
                   <alias>mysql</alias>
                   <name>mysql:${docker.mysql.version}</name>
                   <run>
-                    <cmd>--skip-log-bin --server-id=1 
--sort_buffer_size=348M</cmd>
+                    <cmd>--skip-log-bin --server-id=1 --sort_buffer_size=348M 
--character-set-server=utf8mb4 --collation-server=utf8mb4_bin</cmd>
                     <env>
                       <MYSQL_ROOT_PASSWORD>password</MYSQL_ROOT_PASSWORD>
                       <MYSQL_DATABASE>syncope</MYSQL_DATABASE>
@@ -916,6 +916,7 @@ under the License.
                   <alias>mariadb</alias>
                   <name>mariadb:${docker.mariadb.version}</name>
                   <run>
+                    <cmd>--character-set-server=utf8mb4 
--collation-server=utf8mb4_bin</cmd>
                     <env>
                       <MYSQL_ROOT_PASSWORD>password</MYSQL_ROOT_PASSWORD>
                       <MYSQL_DATABASE>syncope</MYSQL_DATABASE>