Page 1 of 1
phpMyAdmin Mass Collation Possible?
Posted: Thu Feb 15, 2007 9:03 pm
by Auron the Paladin
I want to change all the tables in my database to a certain collation. However, I have 148 tables in the database. Is it possible to change the collation of the tables all at once or a quicker way?
Posted: Fri Feb 16, 2007 2:59 pm
by Lixas
method number one: write a script that could do this automaticaly
method number two: explanation is here
http://lists.mysql.com/mysql/186286
Posted: Wed Sep 05, 2007 4:57 pm
by Gyanu
I think it is not possible.
It will be better to create a new database
Posted: Thu Aug 21, 2008 6:00 am
by Alwahsh
I don't know but I think it's possible by the way Lixas said