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

Thanks Alvaro.  What do I do with a apostrophe  (such as I've)?

Mary


----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
Sent: Friday, March 12, 2010 12:48 PM
To: Wang, Mary Y
Cc: Michał Pawlikowski; pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8":0x93 Error

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
restoredmy database with the pg_dump --insert option.  That row didn't get inserted to the table.  What's interesting
aboutthis 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
withinthe 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