Change collation

Customer Support Database Support
1

Hi,

I want to change the collation in my mySql db which is in 4.0.27 server with mySql 4.1.7 client.
I cannot do it using phpMyadmin.
How i will change it?
Thanks

2

It is not possible to change collation in MySQL 4.0 version.