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