如何让MariaDB客户端使用UTF-8?我在使用相同版本的MySQL时没有这个问题。我试图在不通过客户端发布SET NAMES
的情况下这样做。我得到latin1与cmd行客户端和php的mysqli驱动程序。
print_r(mysqli_get_charset($link));
stdClass Object
(
[charset] => latin1
[collation] => latin1_swedish_ci
[dir] =>
[min_length] => 1
[max_length] => 1
[number] => 8
[state] => 1
[comment] =>
)
下面是命令行客户端的输出:
echo "show variables like 'char%';" | mysql -u root -p
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
这是我的my.cnf文件。
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
default-character-set=utf8
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
default-character-set = utf8
default-collation = utf8_general_ci
character_set_server = utf8
collation_server = utf8_general_ci
init_connect='SET NAMES utf8'
key_buffer = 512M
max_allowed_packet = 64M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 4M
query_cache_size = 64M
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 64M
default-character-set=utf8
[mysql]
no-auto-rehash # faster start of mysql but no tab completition
default_character_set=utf8
[isamchk]
key_buffer = 128M
[client-server]
default-character-set=utf8
[client-mariadb]
default-character-set=utf8
!includedir /etc/mysql/conf.d/
问题是,无论如何都不应该通过客户端发出SET NAMES
因为这个命令是不够的,除了服务器之外,您还必须设置客户机编码。这只能通过使用API函数来实现。因此,在您的PHP脚本中,您应该通过msql(i)_set_charset()
函数或DSN来设置客户端编码,而不是发出SET NAMES
查询。
因此,请记住,更改默认编码并不能免除在PHP中设置编码的必要性。
然而,utf-8
作为默认值比latin1
更有意义。因此,在my.ini
[mysqld]
下添加以下行init-connect='SET NAMES utf8'
我找到了问题所在。我使用他们的repo和apt-get安装了mariadb。一切似乎都很顺利。我有这些非常缓慢的重启使用命令service mysql restart
和编码问题。我注意到有2个mysqld实例,我继续发送了一个kill命令,我不建议kill -9,常规的kill工作得很好。然后做了一个service mysql restart
,它开始得很快,字符编码如预期的那样工作。