Skip site navigation (1) Skip section navigation (2)

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

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: mhernandez(at)ingenian(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution
Date: 2005-04-27 10:22:29
Message-ID: 87d5sgecyi.fsf@meuh.mnc.ch (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-jdbc by date

Next:From: Anders HermansenDate: 2005-04-27 10:50:49
Subject: Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution
Previous:From: Tom LaneDate: 2005-04-27 04:43:02
Subject: Re: _pg_keyposition is gone in HEAD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group