ERROR: could not convert UTF8 character to ISO8859-1

From: JP Glutting <jpglutting(at)oqua(dot)udl(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: could not convert UTF8 character to ISO8859-1
Date: 2006-03-23 14:55:44
Message-ID: 4422B6F0.4040005@oqua.udl.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have seen several people with this same error. I get mine when trying
to backup using pg_dump, causing my backups to fail.

I am using PostgreSQL 8.1 on Windows XP.The databases are in UTF8. I get
the same error from the command line and using pgadmin3.

Has anyone found a solution for this? Looking around online, I see that
this supposedly codes for a lowercase a with a circumflex (which I don't
have in tha table thet triggeres the error), but that this may be the
first part of a three-byte sequence that codes for something else.

Does anyone know of a way to pinpoint the character in the database? I
am not sure how to search for a raw unicode character through psql or
pgadmin...

Thanks for any help!

JP

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JP Glutting 2006-03-23 15:03:24 Re: ERROR: could not convert UTF8 character to ISO8859-1
Previous Message A. Kretschmer 2006-03-23 13:25:52 Re: Logging of sql statements?