更改phpmyadmin中的默认排序规则 [英] change default collation in phpmyadmin

问题描述

在我看来，phpMyAdmin默认使用归类latin1_swedish_ci导入表，我该如何更改?

It seems to me that phpMyAdmin imports tables by default with collation latin1_swedish_ci, how i change this?

推荐答案

在您的Mysql配置中，更改[mysqld]选项卡下的default-character-set操作.例如:

In your Mysql configuration change the default-character-set operative under the [mysqld] tab. For example:

[mysqld]
default-character-set=utf8

别忘了之后重新启动Mysql服务器，以使更改生效.

Don't forget to restart your Mysql server afterwards for the changes to take effect.

这篇关于更改phpmyadmin中的默认排序规则的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！