From: | Florian Helmberger <fh(at)25th-floor(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | mandana(dot)mokhtary(at)wspgroup(dot)se |
Subject: | Re: Encoding Problem |
Date: | 2011-09-12 11:55:12 |
Message-ID: | 4E6DF320.9040908@25th-floor.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)25th-floor(dot)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
---------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Rainer Leo | 2011-09-12 13:03:41 | Best procedure for restricted access |
Previous Message | Mokhtary, Mandana | 2011-09-12 11:38:39 | Encoding Problem |