Re: JDBC to load UTF8@psql to latin1@mysql - Mailing list pgsql-general

From Adrian Klaver
Subject Re: JDBC to load UTF8@psql to latin1@mysql
Date
Msg-id 50CB495D.3080208@gmail.com
Whole thread Raw
In response to Re: JDBC to load UTF8@psql to latin1@mysql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.klaver@gmail.com


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Implicit casts to array types
Next
From: Tom Lane
Date:
Subject: Re: Problem starting PG-9.2 on non-default port