MySQL 'latin1_shwdish_ci' → 'utf8_general_ci' - Cacher Snippet

2/29/2020 - 2:48 PM

MySQL 'latin1_shwdish_ci' → 'utf8_general_ci'

mysql-latin1-utf8

/etc/mysql/

my.conf

Add to appropriate sections:

[mysqld]
	character-set-server=utf8
	collation-server=utf8_general_ci
	init-connect="SET NAMES utf8"
	skip-character-set-client-handshake

[client]
	default-character-set = utf8

[mysqldump]
	default-character-set = utf8

[mysql]
	default-character-set = utf8