Problem with accent Import to MySQL/Linux from MySQL Windows

Daedalus.OS

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

Sep 4 '05 #1

Daedalus.OS

Problem Solved...


"Daedalus.OS" <ar**************@videotron.ca> wrote in message
news:NZ*********************@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 č
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

Sep 5 '05 #2

David Quinton

On Mon, 5 Sep 2005 18:01:26 -0400, "Daedalus.OS"
<ar**************@videotron.ca> wrote:

Problem Solved...

Please tell us - for the archives...
--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

Sep 6 '05 #3

Daedalus.OS

"David Quinton" <us****************@REMOVETHISBITbizorg.co.uk> wrote in
message news:me********************************@4ax.com...

On Mon, 5 Sep 2005 18:01:26 -0400, "Daedalus.OS"
<ar**************@videotron.ca> wrote:

Problem Solved...

Please tell us - for the archives...

Finally it wasn't MySQL but apache. After some verification I noticed that
internally the database was perfect. Apache was set with DefaultCharset
utf-8. we changed it to iso8859-1 and the problem was solved.
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

Sep 6 '05 #4