Special Character translation with export help needed

I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:

View of data from phpMyAdmin:
Habitat is a =89=DB=CFwhat you see is what you get=89=DB? or =
=89=DB=CFWYSIWYG=89=DB?

View from table dump via phpMyAdmin export:
Habitat is a =C3=A2=E2=82=AC=C5=93what you see is what you get=C3=A2=E2=82=
=AC? or
=C3=A2=E2=82=AC=C5=93WYSIWYG=C3=A2=E2=82=AC?

View from table dump via mysqldump:
Habitat is a =C3=83=C2=A2=C3=A2=E2=80=9A=C2=AC=C3=85=E2=80=9Cwhat you =
see is what you get=C3=83=C2=A2=C3=A2=E2=80=9A=C2=AC?
or =C3=83=C2=A2=C3=A2=E2=80=9A=C2=AC=C3=85=E2=80=9CWYSIWYG=C3=8 3=C2=A2=C3=A2=
=E2=80=9A=C2=AC?

The view of the data via phpMyAdmin seems to be the closest to what I
need.
The special characters are created by flash then saved in the mysql (
4.1.13 )
database. Now I'm moving them to a different mysql ( 4.1.14 ) database.

Is there a better way to swap databases that will prevent the special
characters from being translated?

Thanks,
Boysenberry

boysenberrys.com | habitatlife.com | selfgnosis.com


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules [at] m.gmane.org
Boysenberry Payne [ Di, 08 November 2005 03:27 ] [ ID #1048614 ]
Datenbanken » gmane.comp.db.mysql.perl » Special Character translation with export help needed

Vorheriges Thema: dbd::mysql install troubles
Nächstes Thema: Re: $dbh->column_info changed behaviour between 5.0 and 4.1? Dugin DBD::mysql