Special Character translation with export help needed
Boysenberry Payne <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
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 “what you see is what you getâ€? or “WYSIWYGâ€? View from table dump via phpMyAdmin export: Habitat is a √¢‚Ǩ≈ìwhat you see is what you get√¢‚Ǩ? or √¢‚Ǩ≈ìWYSIWYG√¢‚Ǩ? View from table dump via mysqldump: Habitat is a √ɬ¢√¢‚Äö¬¨√Ö‚Äúwhat you see is what you get√ɬ¢√¢‚Äö¬¨? or √ɬ¢√¢‚Äö¬¨√Ö‚ÄúWYSIWYG√ɬ¢√¢‚Äö¬¨? 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/[email protected]