On 5 Jun 2010, at 4:44, Wang, Mary Y wrote: > Hi, > > I'm getting this error from postgres " ERROR: character 0x90 of encoding > "WIN1252" has no equivalent in "UTF8" " and from a dump file when I tried to > use psql command to restore the dump. > > I have SET client_encoding = 'win1252' in the dump file. > > Any ideas?
Apparently Win1252 is the not the right encoding to use for your data, as 0x90 is undefined in that encoding. See http://dbaspot.com/forums/ingres-database/414795-re-info-ingres-fw-how-insert-control-charactersintovarcharcolumn.html for someone with the same problem (on Ingres) and links to two different code pages listing the characters therein. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4c0a0c3a10151431365867! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
