March 1, 2018
MySQL: 修改默认编码, MySQL / MariaDB: Set Character Set and Collation to UTF8, Mysql2::Error: Incorrect string value: ‘\xE2\x80\xA8\x09
发现phpmyadmin默认是latin字符编码,导致某些特殊字符,或者乱码字符无法保存,常有的报错类似:
Mysql2::Error: Incorrect string value: '\xE2\x80\xA8\x09
1. 那么首先看一下我们的mysql默认字符是什么:
sudo mysql
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.45, for Win32 (ia32)
Connection id: 25
Current database: spiel0
Current user: root@localhost
SSL: