CODEWITHSUNDEEP
mysqlphpmyadmin
Stephen305
Stephen305

Reputation: 1097

Set default collation phpmyadmin

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

The columns still default to latin1_swedish_ci. Any ideas?

PHPmyadmin 3.5.2 MySQL 5.1.44

Upvotes: 5

Views: 6266

Answers (2)

Ihsan Praditya
Ihsan Praditya

Reputation: 71

Log in to phpMyAdmin. Go to "Variables" menu between "Replication" and "Charsets". Then change collation server's variable to `utf8mb4_unicode_ci.

enter image description here

Upvotes: 0

Ryan
Ryan

Reputation: 115

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.

Upvotes: 4

Related Questions