Of course it depends on your needs, but I think that downgrading from utf8 to latin1 generally isn't a good idea. If it is possible then consider upgrading the mysql server.
I have utf8 on mysql 4.0 servers. I know they are limitations/problems but it has been running smoothly on my sites so far.
Skip the iconv step and see how it works for you.
Another option (the one I used) was
1) create the tables (empty) on the 4.0 server
(kernel/sql/mysql/kernel_schema.sql ) 2) dump only the datas from the 4.1 database
Firstly: for the love of God (or whatever you love), keep everything everything in utf from the beginning. Saves so much headache.. i know..
For dump conversion see my solution on this thread: http://ez.no/community/forum/general/convert_from_iso_8859_1_encoding_to_utf_8/re_convert_from_iso_8859_1_encoding_to_utf_8__9
It has worked for me. But its crude, so heed the warnings. Might not work for you. But trying wont hurt.
Certified eZ developer looking for projects.
zurgutt at gg.ee
You must be logged in to post messages in this topic!