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

spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 824516
    • Gender:Male
  • point d’amour
 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
« Last Edit: 22 Jul, 2021, 15:15:16 by spiros »


 

Search Tools