Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
Cc: Michał Pawlikowski <misiekbest(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
Date: 2010-03-12 20:48:28
Message-ID: 20100312204828.GH3663@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wang, Mary Y escribió:
> Hi Michal,
>
> Thanks for the info. However, the text that the user entered is all in English letters. I saw this error, when I restored my database with the pg_dump --insert option. That row didn't get inserted to the table. What's interesting about this problem is that when I manually entered the data to the database via psql, this record made it without any problems. It's still a mystery to me .....

Well, 0x93 is certainly not an english letter; most likely it's a
win1252-encoded curved single quote. That's not within the ASCII
definition. You can probably insert the data by declaring

SET client_encoding TO 'win1252'

at the start of the file.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wang, Mary Y 2010-03-12 20:51:24 Re: ERROR: invalid byte sequence for encoding "UTF8":0x93 Error
Previous Message Wang, Mary Y 2010-03-12 20:20:28 Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error