encoding shp2pgsql/ client encoding - Mailing list pgsql-admin

From Melanie Hofmann
Subject encoding shp2pgsql/ client encoding
Date
Msg-id 2119adb60911260558i7e1ed36cg521e35b6841d4b23@mail.gmail.com
Whole thread Raw
Responses Re: encoding shp2pgsql/ client encoding  (Brian Modra <epailty@googlemail.com>)
List pgsql-admin
Hello,

I'm a very big problem. I want to load shapefiles in a postgresql with shp2pgsql and psql. So i create the statement on a windows DOS console. I get below error FEHLER:  ungültige Byte-Sequenz für Kodierung UTF8 0xd627.

My Client_encoding is

template_postgis=# SHOW CLIENT_ENCODING;
 client_encoding
-----------------
 UTF8
(1 row)

and my database encoding is also UTF8, only my shapefile is not in UTF8.

I make a few trails to change the client encoding, but nothing realy works.

What can I do?
Can anybody help me?

Thanks.

Regards MisterX

pgsql-admin by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Replication solution
Next
From: Brian Modra
Date:
Subject: Re: encoding shp2pgsql/ client encoding