Algirdas Varnagiris

I needed to move date from one database to another.The source DB was MySQL 4.0 and the destination was MySQL 5.1. And all the problems was with UTF-8 symbols. I couldn’t get it to work on MySQL 5.1. I search on the internet and figured out that MySQL 4.0 does not support UTF-8 and it is supported only from MySQL 4.1.
You can store UTF-8 date on MySQL 4.0 but it’s not encoded using UTF-8. The data is encoded using the default encoding ‘Latin1′, so the only thing what you need is to make an export file and upload using PhpMyAdmin, but dont forget to select that the data is encoded ‘Latin1′ and not UTF-8.