Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution - Mailing list pgsql-jdbc

From Guillaume Cottenceau
Subject Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution
Date
Msg-id 87d5sgecyi.fsf@meuh.mnc.ch
Whole thread Raw
In response to ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution  (Mauricio Hernández Durán <mhernandez@ingenian.com>)
Responses Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution
Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1
List pgsql-jdbc
Mauricio Hernández Durán <mhernandez 'at' ingenian.com> writes:

> Hi all!
>
> We encountered the same problem most people have had using latin1 or
> unicode for spanish characters upon inserting or updates:
>
> ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1

Iconv actually agrees that this UTF-8 character cannot be
converted to ISO8859-1.

I can print UTF-8's 0x00EF which gives "ï".

Then if I manually input "ï", the bytes in UTF-8 to do that are
0xC3AF, and this can be converted to ISO8859-1 (it is 0xEF).

Isn't there a problem with your UTF-8 data containing 0x00EF?

--
Guillaume Cottenceau

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: _pg_keyposition is gone in HEAD
Next
From: Anders Hermansen
Date:
Subject: Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution