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

From Tom Lane
Subject Re: JDBC to load UTF8@psql to latin1@mysql
Date
Msg-id 310.1355499301@sss.pgh.pa.us
Whole thread Raw
In response to Re: JDBC to load UTF8@psql to latin1@mysql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: JDBC to load UTF8@psql to latin1@mysql  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: JDBC to load UTF8@psql to latin1@mysql  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
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?

            regards, tom lane


pgsql-general by date:

Previous
From: joshua
Date:
Subject: Re: Implicit casts to array types
Next
From: Tom Lane
Date:
Subject: Re: Implicit casts to array types