Re: JDBC to load UTF8@psql to latin1@mysql

On 12/14/2012 07:35 AM, Tom Lane wrote:
> I wrote:
>> Meh. That character renders as \310 in your mail, which is not an
>> assigned code in ISO 8859-1. The numerically corresponding Unicode
>> value would be U+0090, which is an unspecified control character.
>
> Oh, scratch that, apparently I can't do hex/octal arithmetic in my
> head first thing in the morning. It's really U+00C8 which is perfectly
> valid. I can't see a reason why that character and only that character
> would be problematic --- have you done systematic testing to confirm
> that that's the only should-be-LATIN1 character that fails?

This is where I am confused, in one of the original posts the OP said:

"JAVA codes work for most of characters, but not "-È"."

>
> regards, tom lane
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com