Re: UTF8 data import problem

[Donal Lynch]

> insert into test values('OlomouckÃ?');
> Incorrect string value '\xC3\x0D' for column 's'
Is this real data? Maybe the word actually does end in 'Ã?', but it's more likely that the actual ending has been lost in a previous conversion.

> Note that '\xC3' is the UTF8 code for the A with a
> tilde accent ~.
It's the Unicode (and the latin1) for à alright, but characters between 0x80 and 0xff are converted into two bytes in utf8. It looks like what's in the file might be latin1.