Re: UTF8 data import problem

[Peter Naus]

Actually, it gets worse... I finally seemed to have been able to import a stringfield containing UNICODE characters into the destination MySQL table by using a binary BLOB field, but it looks as if every character in that column has been converted to binary, and MySQL seems to be unable to decode the BLOB field in any meaningful way without first throwing an error on any attempt to convert the BLOB data back into any textual format.

It also seems to have not only NOT imported real DBCS unicode characters from the source table (so I've been unable to import any data from any row of the source table that contains any DBCS characters), but it's now encoded "normal" accented ASCII characters in such a way that when I try and convert the BLOB field back into UNICODE (OR UTF or ISO) NVarChar, it thinks these "normal" accented characters are incorrectly formatted, and won't allow me to convert these data fields back to meaningful strings.

I strongly suspect this is just because I'm trying to coerce MySQL into doing something I shouldn't, but I'm getting frustrated here. That sound you can hear?
It's my brain melting...