encoding problem

Hi All

I was trying to load shapfiles into the postgre9, then I used this command:

C:\Program Files\PostgreSQL\9.0>shp2pgsql -s 2400 -c -W LATIN1 C:/Projects/Mandana/OBO/WSPBakgrund_shp/Primärkartan.shp | psql -U postgres OBO

Then I had a UTF encoding problem. (invalid byte sequence for encoding UTF8)

Then I followed these steps in order to set client encoding:

1. shp2pgsql -s 2400 -c -W LATIN1
C:/Projects/Mandana/OBO/WSPBakgrund_shp/Primärkartan.shp > data.sql

this creates the data.sql with the results of shp2pgsql.

2. psql -U postgres OBO

this connects you to our database.

3. set client_encoding to latin1;

this sets the client_encoding.

4. \i data.sql

this executes the generated data.sql file

But, can anyone tell me how can I insert the data.sql into the postgres? Does it contain shapfiles?

Any help would be appreciated.

Vänliga hälsningar

Mandana Mokhtary
Geografisk IT och mätningsteknik

WSP Samhällsbyggnad
SE-121 88 Stockholm-Globen
Besök/visit: Arenavägen 7
Tel/phone: +46 (0)8 688 60 00
Fax: +46 (0)8 688 69 99
Mobil/mobile: +46 (0)70 297 48 10
www.wspgroup.se <http://www.wspgroup.se/>

WSP är ett globalt analys- och teknikföretag som erbjuder konsulttjänster för hållbar samhällsutveckling inom Hus & Industri, Transport & Infrastruktur samt Miljö & Energi.

CONFIDENTIAL
This e-mail is confidential to the named recipient. If you have received a copy in error, please destroy it. You may not use or disclose the contents of this e-mail to anyone, nor take copies of it. The only copies permitted are (1) by the named recipient and (2) for the purposes of completing successful electronic transmission to the named recipient and then only on the condition that these copies, with this notice attached, are kept confidential until destruction.