phpmyadmin change the char_set of existing table

Question

How can I change the CHAR_SET of an existing database/table in phpmyadmin ?

The collation of tables can be changed by clicking the table name -> operations but I did not find how to change the CHAR_SET

I am trying to export a 5.5 database with utf8mb4 to a 5.0 database (no utf8mb4)

best regards

for people having the same problem here is a post that has the SQL solution on StackOverflow

possible duplicate of [Mysql change default table charset to database charset](http://stackoverflow.com/questions/7028610/mysql-change-default-table-charset-to-database-charset) — zerkms, Apr 23 '14 at 00:57

score 0 · Accepted Answer · edited May 23 '17 at 11:57

0

If you want to change the table default character set to a new character set, use a statement like this:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

So query will be:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8mb4;

In PHPMyadmin:

You need to go to phpmyadmin > information_schema > schemata > change your DEFAULT_CHARACTER_SET_NAME with query

edited May 23 '17 at 11:57

Community

answered Apr 23 '14 at 00:57

Lucas Henrique

my question was if it is possible to do this IN phpmyadmin. Your answer is just a copy paste of the post to which I linked. – anatak Apr 23 '14 at 01:01
Thank you for pointing out where I can find the informaration. But it seems that it is not possible to do this in the gui in phpmyadmin. It is only possible to do this using a SQL query. Thank you now I know and I don't have to look any further. – anatak Apr 23 '14 at 01:58

1 Answers1