I am having trouble exporting records from one MySQL db to a .sql file, and then importing into my local MySQL here on my machine. It is doing something funky w/ the ASCII code characters. For example, I'm trying to export a record that contains the ™ mark. When I export from MY machine, the record looks like this:
INSERT INTO `categories` (`cat_id`, `cat_title`) VALUES (1, 'UltraMAX™ Standard and Plus Series');
But when I do it from the live server, that record comes through like this:
INSERT INTO `categories` (`cat_id`, `cat_title`) VALUES (1, 'UltraMAXâ„¢ Standard and Plus Series');
I have tried every possible option from the dropdown of SQL export compatibility on the PHP MyAdmin interface, and it does this same funky thing to the ™ mark w/ each setting. Is there something else that I'm missing?
The live server is running MySQL 4.1.12 and we're using phpMyAdmin 2.6.1 to interface w/ it.
Thanks,
Shaun
