Hex entities preventing import

[Mary Fredborg]

When trying to import tables from a mysqldump generated file, I get several of this type of error:

Error 1366 (HYOOO): Incorrect string value '\xC5\xBCam, ...' for column 'message' at row 76

The table (and database) is latin1 and appears to have hex entities in it (some are English characters, some are not).

How can I correct this? I've done lots of searching through Google, but can't seem to find an answer.

Here's what I used to make the table dump:

/usr/local/bin/mysqldump
	--default-character-set=latin1
	--user=username
	--password=password
	--complete-insert
	--extended-insert
	--quick
	--compact
	--lock-tables=false
	--skip-add-locks
	--databases db_name
	--tables table_name

Ironically I was doing this so that I could work on a local copy, to convert to utf8 through binary fields. Right now I can't even get the table imported.



Edited 1 time(s). Last edit at 06/19/2007 02:49PM by Mary Fredborg.