MySql character problems

i am moving my sites to another hosting company

but my ex-hosting server has a diffenet mysql version so i am converting databases to 4.0 . (i haven't got shell access)

before that all of the databases back ups gave error after the dump.

Now when i convert and dumped them and they are working but now the special Turkish Languages characters are destroyed they are like this.

Ý >> i (normal one)

ü >> ü (normal one)

.....


is there a way to correct this?

can i find and change all of them via phpmyadmin? is there command on phpmyadmin?

Thank you very much your future responds



thanks for your replies...

 

 

 

 

Top