[ADMIN] encoding problem

2011-09-13 Thread Mokhtary, Mandana
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 fo

Re: [ADMIN] Encoding Problem

2011-09-12 Thread Florian Helmberger
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:\Pragr

[ADMIN] Encoding Problem

2011-09-12 Thread Mokhtary, Mandana
Hi 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

[ADMIN] Encoding problem using pg_dumpall

2009-01-29 Thread Moshe Ben-Shoham
Hi, I have a database with encoding UTF-8 installed on Windows, and I try to dump it using pg_dumpall, on the machine on which the database is installed. I get the following error message: C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall -U admint > c:\temp\dbdump.sql pg_dump: SQL command fa

Re: [ADMIN] encoding problem

2003-03-25 Thread Fouad Fezzi
-Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de Alexey A. Britchko Envoye : mardi 25 mars 2003 07:08 A : [EMAIL PROTECTED] Objet : [ADMIN] encoding problem Hi there How did upgrade from pgsql 6.x to pgsql 7.x: 1. Dumped database 2. ./configure --e