设置默认排序规则phpmyadmin [英] Set default collation phpmyadmin

问题描述

我试图更改phpmyadmin中的默认排序规则，以便在创建表时，列的排序规则为utf8_unicode_ci.我已经尝试了以下方法，但它不起作用.

I am trying to change the default collation in phpmyadmin so that when I create a table, the collation of the columns is utf8_unicode_ci. I have tried the following and it does not work.

[mysqld]
collation_server=utf8_unicode_ci
character_set_server=utf8
default-character-set=utf8

这些列仍默认为latin1_swedish_ci.有什么想法吗?

The columns still default to latin1_swedish_ci. Any ideas?

PHPmyadmin 3.5.2 MySQL 5.1.44

PHPmyadmin 3.5.2 MySQL 5.1.44

推荐答案

登录phpMyAdmin. 从左侧列表中选择数据库. 单击顶部选项卡中的操作". 在排序规则"框中，从下拉菜单中选择新的排序规则，然后单击执行".

Log into phpMyAdmin. Select your database from the list on the left. Click on "Operations" from the top set of tabs. In the Collation box, choose your new collation from the dropdown menu, then click go.

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