unicode_ci general_ci beda di cbt per tanggal 20 november 2025

 
saya cek tadi di cbt:
MariaDB [(none)]> -- cek variabel server
MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set_server';
+----------------------+---------+
| Variable_name        | Value   |
+----------------------+---------+
| character_set_server | utf8mb4 |
+----------------------+---------+
1 row in set (0.002 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'collation_server';
+------------------+--------------------+
| Variable_name    | Value              |
+------------------+--------------------+
| collation_server | utf8mb4_general_ci |
+------------------+--------------------+
1 row in set (0.002 sec)

MariaDB [(none)]> 
MariaDB [(none)]> -- ganti 'your_db_name' dengan nama database Moodle Anda
MariaDB [(none)]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
    ->   FROM information_schema.SCHEMATA
    ->  WHERE SCHEMA_NAME = 'moodle';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4                    | utf8mb4_unicode_ci     |
+----------------------------+------------------------+

di SiM
MariaDB [(none)]> -- cek variabel server
MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set_server';
+----------------------+---------+
| Variable_name        | Value   |
+----------------------+---------+
| character_set_server | utf8mb4 |
+----------------------+---------+
1 row in set (0.002 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'collation_server';
+------------------+--------------------+
| Variable_name    | Value              |
+------------------+--------------------+
| collation_server | utf8mb4_general_ci |
+------------------+--------------------+
1 row in set (0.002 sec)

MariaDB [(none)]> 
MariaDB [(none)]> -- ganti 'your_db_name' dengan nama database Moodle Anda
MariaDB [(none)]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
    ->   FROM information_schema.SCHEMATA
    ->  WHERE SCHEMA_NAME = 'moodle2';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4                    | utf8mb4_general_ci     |
+----------------------------+------------------------+
1 row in set (0.000 sec)