Special Character translation with export help needed
am 08.11.2005 03:27:05 von Boysenberry PayneI'm having difficulty getting certain special characters to stay the=20
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a Û=CFwhat you see is what you getÛ? or =
Û=CFWYSIWYGÛ?
View from table dump via phpMyAdmin export:
Habitat is a ââ¬Å=93what you see is what you getââ=
? or=20
ââ¬Å=93WYSIWYGââ?
View from table dump via mysqldump:
Habitat is a âââ¬Ã
âwhat you =
see is what you getâââÂ?=20
or âââ¬Ã
âWYSIWYG=C3=8 3¢â=
âÂ?
The view of the data via phpMyAdmin seems to be the closest to what I=20
need.
The special characters are created by flash then saved in the mysql (=20
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=20
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 @m.gmane.org