Translation - Μετάφραση

Resources, Technical Assistance and Technology News => Translator resources => Tips on Using Computers => Topic started by: spiros on 22 Jul, 2021, 15:13:34

Title: Changing the Default Server Character Set To UTF-8 (MySQL, MariaDB)
Post by: spiros on 22 Jul, 2021, 15:13:34
 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 (https://mariadb.com/kb/en/setting-character-sets-and-collations/#example-changing-the-default-character-set-to-utf-8)
Change MySQL default character set to UTF-8 in my.cnf? - Stack Overflow (https://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf-8-in-my-cnf)

edit my.cnf | cPanel Forums (https://forums.cpanel.net/threads/edit-my-cnf.223771/)