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

2010-03-12 Thread Wang, Mary Y
h 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: Alv

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

2010-03-12 Thread Wang, Mary Y
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.

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

2010-03-12 Thread Alvaro Herrera
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 prob

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

2010-03-12 Thread Wang, Mary Y
h 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. >> &

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

2010-03-08 Thread Michał Pawlikowski
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-

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

2010-03-08 Thread Albe Laurenz
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 > con

[GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error

2010-03-07 Thread Wang, Mary Y
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_encod