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

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 ..... 

Mary


-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michal Pawlikowski
Sent: Monday, March 08, 2010 4:38 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error

On Mon, Mar 8, 2010 at 9:17 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> Mary Y Wang wrote:
>> I got the following error and not sure how to fix it.
>> "psql:/tmp/030610dumpfile.txt:4369: ERROR:  invalid byte sequence for
>> encoding "UTF8": 0x93

look here:
http://www.depesz.com/index.php/2010/03/07/error-invalid-byte-sequence-for-encoding/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general