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: [email protected]
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
---------------------------------------
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
