Hurrican19@stripped <mailto:Hurrican19@stripped> wrote on Thursday, January
06, 2005 4:57 PM:
> Sorry, forgot the attachments. These are the same exact two
> avatars from the same user, using my 3.23 backup, for the
> good avatar, then the 4.18 bad avatar
Looks like a character set issue - what's the column type, BLOB or TEXT or
something in between?
This could be due to the server converting UTF-8 into a different character
set. Characters such as 0x8F (143 decimal) and 0x8D are being converted into
0x3F, which is "?" and often indicates that the character does not exist in
the target collation. Basically, MySQL is treating the content as text, and
replacing characters which it doesn't understand with "?". Try using a
different collation or character set, and importing again?
Unfortunately, the conversion is not reversible - a set of characters have
been replaced with a single character, so although the image is the same
binary size, some of the data has been permanently lost unless you can
restore from the backup.
cheers,
Tom
