Changing the Default Server Character Set To UTF-8 (MySQL, MariaDB)

[spiros]

 Changing the Default Server Character Set To UTF-8 (MySQL, MariaDB)

To change the default character set from latin1 to UTF-8, the following settings should be specified in the my.cnf configuration file.

Code: [Select]

[client]
...
default-character-set=utf8mb4
...
[mysql]
...
default-character-set=utf8mb4
...
[mysqld]
...
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
...Setting Character Sets and Collations - MariaDB Knowledge Base
Change MySQL default character set to UTF-8 in my.cnf? - Stack Overflow

edit my.cnf | cPanel Forums