Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8":0x93 Error
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-ow...@postgresql.org [mailto:pgsql-general-ow...@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:alvhe...@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 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 Herrerahttp://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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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:alvhe...@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 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 Herrerahttp://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
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 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 Herrerahttp://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
Re: [GENERAL] 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 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-ow...@postgresql.org [mailto:pgsql-general-ow...@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 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
On Mon, Mar 8, 2010 at 9:17 AM, Albe Laurenz 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
Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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 controlled by "client_encoding"." Any ideas? I'm running on Postgres 8.3.8. Mary -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general