Hi Steve,
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from the system. Here's what I've discovered so far:
' becomes ^�^�, e.g. didn't becomes didn�^�^�t
- becomes �^�^�, e.g. 1-2 becomes 1�^�^�2
� becomes è, e.g. Entr�e becomes Entrèe
What gives?
Looks like an application of the GIGO (Garbage In, Garbage Out) principle to me. The above data wouldn't have happened to come from a Microsoft Office application, would it?
Looks like "Smart Quotes" etc., strikes again, to me.
Regards,
Jeremy
-- Jeremy Cole Technical Yahoo - MySQL (Database) Geek
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
