Re: Encoding Problem - Mailing list pgsql-admin

From Florian Helmberger
Subject Re: Encoding Problem
Date
Msg-id 4E6DF320.9040908@25th-floor.com
Whole thread Raw
In response to Encoding Problem  ("Mokhtary, Mandana" <mandana.mokhtary@wspgroup.se>)
List pgsql-admin
On 12.09.11 13:38, Mokhtary, Mandana wrote:

> I am trying to load shapfiles into the postgreSQL9.0. The database
> encoding is UTF8.
>
> My shapfiles coming from Sweden, so there are some Swedish alphabet in
> the fields name and also inside columns data.
>
> I used this command to load shapfiles:
>
> C:\Pragram Files\PostgreSQL\9.0> shp2pgsql -s 2400 –c –W LATIN1
> C:/project/Mandana/OBO/WSPbackground_shp/Primärkartan.shp |psql –U
> postgres OBO
>
> I could insert shapfiles which do not have Swedish alphabet in their
> fields name or data inside the columns, but I could not load others that
> have Swedish alphabet.
>
> I get this ERROR:
>
> *invalid byte sequence for encoding “UTF8”:0xe4726b*
>
> Any help would be so appreciated.

Hi!

You might need to set the CLIENT_ENCODING to latin1.

http://www.postgresql.org/docs/9.0/static/multibyte.html

Regards,
Florian

--

Florian Helmberger --------------------

25th-floor - Operating Custom Solutions
de Pretis & Helmberger KG

Seidengasse 33-35/Top 19
1070 Wien, Austria

Mail: fh@25th-floor.com
Web : http://www.25th-floor.com
Tel.: +43 1 / 512 82 89 - 60
Fax : +43 1 / 512 82 89 - 76
Mob.: +43 699 / 109 24 24 5
---------------------------------------

pgsql-admin by date:

Previous
From: "Mokhtary, Mandana"
Date:
Subject: Encoding Problem
Next
From: Rainer Leo
Date:
Subject: Best procedure for restricted access