Actually, it came from Mysql 4.1.1 (not 4.1.3 as I mentioned earlier).
When I do select queries, the data displays just fine, but when I dump,
I get this garbage.
Jeremy Cole wrote:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
