invalid byte sequence for encoding "UTF8"

From: "Gary Benade" <gary(at)softwareguys(dot)co(dot)za>
To: <pgsql-general(at)postgresql(dot)org>
Subject: invalid byte sequence for encoding "UTF8"
Date: 2007-01-16 13:40:52
Message-ID: TSGSERVERWzUMIa2nXO0000015d@softwareguys.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I used shp2pgsql.exe to create an import sql for my gis database.
The resultant sql has data like this in it.INSERT INTO "gis"."sa_area" ("label","type","level",the_geom) VALUES ('MÔRELIG','0x2','2','0106000000010000000');
The Ô is ascii char 212.
This wont import, PSQL returns
ERROR: invalid byte sequence for encoding "UTF8": 0xd452
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client-encoding"

TIA
Gary

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Singh Bali 2007-01-16 14:06:49 Dynamic loading of Perl Code in Postgres functions
Previous Message Martijn van Oosterhout 2007-01-16 13:33:44 Re: Need help on SP