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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Wang, Mary Y Sent: Friday, March 12, 2010 12:51 PM To: Alvaro Herrera Cc: Michał Pawlikowski; pgsql-general@xxxxxxxxxxxxxx Subject: 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@xxxxxxxxxxxxxxxxx] Sent: Friday, March 12, 2010 12:48 PM To: Wang, Mary Y Cc: Michał Pawlikowski; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- 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
