Comments - collation_connection change

9 months, 2 weeks ago Renzo Killer

Hello,
Thanks to https://mathiasbynens.be/notes/mysql-utf8mb4
You need to add this line in the server conf :
character-set-client-handshake = FALSE

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

systemctl restart mariadb.service

MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

| collation_connection     | utf8mb4_unicode_ci |
| collation_database       | utf8mb4_unicode_ci |
| collation_server         | utf8mb4_unicode_ci |
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.