im having problems with "migration" from old mysql 4.X database. Goddady's hosting. From the begining, we started with this version of mysql with wordpress for spanish language. In mysql tables, the special characters are saved as
Un millÃ³n para el mejor
I started a new installation of WP. And created a new mysql bd version 5. I couldn't get make it work. Then I tried with a new mysqld bd version 4. All of these operations in same goddady hosting. No worked. My doubt is, which collate have I to use en mysql 5? Keeping in mind that, special chararcter are saved in this way -> Â, QuÃ©, millÃ³n... I could get pass exactly dates from one bd to second, so this is not the problem. WP version is 2.5.1.
I don't know how to know what type of collate used old mysql 4.x. The question is that with this old bd, special characters was showed correctly in the past.
Any help or advice will be helpful :)