Обсуждение: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
Hi All, 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 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlledby "client_encoding"." Any ideas? I'm running on Postgres 8.3.8. Mary
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 > HINT: This error can also happen if the byte sequence does > not match the encoding expected by the server, which is > controlled by "client_encoding"." > > Any ideas? > I'm running on Postgres 8.3.8. You must either change the client encoding to the encoding of the data you are feeding the client, or you must change the data to match the client encoding. Client encoding can be changed with the SQL statement "SET client_encoding = ..." or by setting the PGCLIENTENCODING environment variable. Yours, Laurenz Albe
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/
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
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 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
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
Ok. What was I thinking, the "curved single quote" that you talked about is the apostrophe. It makes sense now. Thanks Mary -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Wang, Mary Y Sent: Friday, March 12, 2010 12:51 PM To: Alvaro Herrera Cc: Michał Pawlikowski; pgsql-general@postgresql.org Subject: Re: [GENERAL] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general