Hi,
I've been asked to transfert a database from a webhoster to another. I think
the database is on a windows box but I'm not 100% shure. The webhoster says
it provides combined hosting on NT/Linux Servers.
After exporting the database with phpMyAdmin I tried to import it to a Linux
server with the mysql>source file.sql command via a ssh access (the file is
40 Mbytes so phpMyAdmin is useless). Everything seemed ok but all accented
characters (à é î ...) and some other special characters were replaced by
"?". I search the net and find somewhere that file from windows might need
to be convert to utf8 before importing them so I tried to convert the file
with iconv then re-import the file. Once again everything seemed to work
fine. The accent problem was solve but another one showed-up. The database
stores some html code where accent and special characters are represented in
their html form like this è or č for "è", now all these have
been replaced by other characters like ©Ã instead of é. When I import
the files(not in utf8) to a windows machine with mysql>source file.sql
command, everything is normal.
Any ideas how to solve this ?
Thanks,
Dae