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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
