Re: encoding shp2pgsql/ client encoding

2009/11/26 Melanie Hofmann <helpmisterx(at)googlemail(dot)com>:
> 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.

Melanie, I am posting this in the off-chance that it may help you. I
faced the same problem as you about 3 years ago, and have not thought
about it since. I put this at the top of the SQL file that I generate
for inserting into the database (other SQLs generated by shp2sql)

set client_encoding to 'LATIN1';

> 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
>

--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/