phpMyAdmin Mass Collation Possible?

Any problem with SQL can be discussed here.
Post Reply
Auron the Paladin
Posts: 86
Joined: Sun Mar 12, 2006 7:13 am
Contact:

phpMyAdmin Mass Collation Possible?

Post 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?


Image
Lixas
Posts: 750
Joined: Wed Feb 16, 2005 4:21 pm

Post 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
Image
Gyanu
Posts: 338
Joined: Mon Jul 30, 2007 2:03 pm
Contact:

Post by Gyanu »

I think it is not possible.

It will be better to create a new database
Image
Alwahsh
Posts: 292
Joined: Sat Aug 16, 2008 7:05 am

Post by Alwahsh »

I don't know but I think it's possible by the way Lixas said
Post Reply