Posted by Daedalus.OS on 09/06/05 01:01

Problem Solved...




"Daedalus.OS" <arsenault.daniel@videotron.ca> wrote in message
news:NZvSe.61765$sY6.1271508@weber.videotron.net...
> 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 &egrave; or &#269;
> for "�", now all these have been replaced by other characters like ��
> instead of &eacute;. 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
>

[Back to original message]