From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
---|---|
To: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: character 0x90 of encoding "WIN1252" has no equivalent in "UTF8" |
Date: | 2010-06-05 08:34:53 |
Message-ID: | 16D29B07-312B-484E-BFE4-6C10AAB72AC8@solfertje.student.utwente.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Manohar Bhattarai | 2010-06-05 11:34:07 | Re: Exception while accessing database |
Previous Message | Konstantin Izmailov | 2010-06-05 06:19:47 | Re: parsing geometric operators |