Skip to main content
Geographic Information Systems

Return to Question

naming
Source Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

ogr2ogr shapefile to PostgreSqlPostgreSQL

Trying to use ogr2ogr to import a shapefile in PostgreSQL. Here is my command:

cd C:\Program Files (x86)\FWTools2.4.7\bin &&SET PGCLIENTENCODING= Windows-1256 &&ogr2ogr -f "PostgreSQL" -a_srs "EPSG:32639" PG:"host=localhost port=5432 dbname=123q user=postgres password=123456" "C:\Users\Desktop\GDB\test.mdb"

displays persianPersian text as a question mark  ,but but when set PGCLIENTENCODING to UTF8 iI catch this error

invalid byte sequence for encoding "UTF8": 0x9d

ogr2ogr shapefile to PostgreSql

Trying to use ogr2ogr to import a shapefile in PostgreSQL. Here is my command:

cd C:\Program Files (x86)\FWTools2.4.7\bin &&SET PGCLIENTENCODING= Windows-1256 &&ogr2ogr -f "PostgreSQL" -a_srs "EPSG:32639" PG:"host=localhost port=5432 dbname=123q user=postgres password=123456" "C:\Users\Desktop\GDB\test.mdb"

displays persian text as a question mark  ,but when set PGCLIENTENCODING to UTF8 i catch this error

invalid byte sequence for encoding "UTF8": 0x9d

ogr2ogr shapefile to PostgreSQL

Trying to use ogr2ogr to import a shapefile in PostgreSQL. Here is my command:

cd C:\Program Files (x86)\FWTools2.4.7\bin &&SET PGCLIENTENCODING= Windows-1256 &&ogr2ogr -f "PostgreSQL" -a_srs "EPSG:32639" PG:"host=localhost port=5432 dbname=123q user=postgres password=123456" "C:\Users\Desktop\GDB\test.mdb"

displays Persian text as a question mark , but when set PGCLIENTENCODING to UTF8 I catch this error

invalid byte sequence for encoding "UTF8": 0x9d

Source Link
sep7696
sep7696
  • 121
  • 5

ogr2ogr shapefile to PostgreSql

Trying to use ogr2ogr to import a shapefile in PostgreSQL. Here is my command:

cd C:\Program Files (x86)\FWTools2.4.7\bin &&SET PGCLIENTENCODING= Windows-1256 &&ogr2ogr -f "PostgreSQL" -a_srs "EPSG:32639" PG:"host=localhost port=5432 dbname=123q user=postgres password=123456" "C:\Users\Desktop\GDB\test.mdb"

displays persian text as a question mark ,but when set PGCLIENTENCODING to UTF8 i catch this error

invalid byte sequence for encoding "UTF8": 0x9d