I use 1and1 as my hosting provider to host my zen-cart shop. I have recently upgraded to SQL5.0 and wanting to move all my old data from my MySQL4.0 to the new 5.0 database. I have Chinese, Japanese and English in my data file. I have tried to export the .sql file in different language setting such as UTF-8, ISO. But I am still getting scrambled char everywhere. UTF-8 should support all my Chinese and Japanese char. I rememeber when loading any of my zen shop pages, the browser will always use UTF-8 and it work fine to display. I have ring 1and1 many times, their tech staff is very friendly but don't seem to make to problem go away.

They advised me to alter database with the following SQL syntax

ALTER DATABASE db_name
CHARACTER SET utf8
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci
DEFAULT COLLATE utf8_general_ci
;

I have try to run that but return 1046 error so no luck either. All I want to do is to move all data from my old MySQL datafile to the new one without showing any ??? and unknow charaters. If someone had ever experiance that issue, could you be so kind and let me know the solution to this. I would be so thankful.

Thank you in advance! Zen Cart forum rocks!!!

Genesis