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 ..... Mary -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Michal Pawlikowski Sent: Monday, March 08, 2010 4:38 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error On Mon, Mar 8, 2010 at 9:17 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
