diff --git a/roles/database_server/molecule/default/tests/test_default.py b/roles/database_server/molecule/default/tests/test_default.py
index e817df811b0988c8270ae5aedea8e624c026c15e..8d56e2f6f25a3af5e87ca7043a53cf7cfb889d00 100644
--- a/roles/database_server/molecule/default/tests/test_default.py
+++ b/roles/database_server/molecule/default/tests/test_default.py
@@ -47,6 +47,13 @@ def test_utf8_configuration(host):
     Tests if UTF-8 configuration has been applied correctly to server.
     """
 
+    expected_character_set_and_collation = {
+        "bullseye": "utf8\nutf8_general_ci\n",
+        "bookworm": "utf8mb3\nutf8mb3_general_ci\n",
+    }
+
+    distribution_release = host.ansible("setup")["ansible_facts"]["ansible_distribution_release"]
+
     with host.sudo():
         assert host.run("mysql -uroot -BNe 'drop database if exists test'").rc == 0
         assert host.run("mysql -uroot -BNe 'create database test'").rc == 0
@@ -54,14 +61,14 @@ def test_utf8_configuration(host):
         check_server = host.run("mysql -uroot test -BNe 'select @@character_set_server; select @@collation_server'")
 
         assert check_server.rc == 0
-        assert check_server.stdout == "utf8\nutf8_general_ci\n"
+        assert check_server.stdout == expected_character_set_and_collation[distribution_release]
 
         check_database = host.run("mysql -uroot test -BNe 'select @@character_set_database; select @@collation_database'")
 
         assert check_database.rc == 0
-        assert check_database.stdout == "utf8\nutf8_general_ci\n"
+        assert check_database.stdout == expected_character_set_and_collation[distribution_release]
 
         check_database = host.run("mysql -uroot -BNe 'select @@character_set_connection; select @@collation_connection'")
 
         assert check_database.rc == 0
-        assert check_database.stdout == "utf8\nutf8_general_ci\n"
+        assert check_database.stdout == expected_character_set_and_collation[distribution_release]