TransWikia.com

ogr2ogr shapefile to PostgreSQL

Geographic Information Systems Asked by sep7696 on August 16, 2021

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

cd C:Program Files (x86)FWTools2.4.7bin &&SET PGCLIENTENCODING= Windows-1256 &&ogr2ogr -f "PostgreSQL" -a_srs "EPSG:32639" PG:"host=localhost port=5432 dbname=123q user=postgres password=123456" "C:UsersDesktopGDBtest.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

One Answer

To fix this problem, check "Beta: Use Unicode utf8 for worldwide language support " box in control panel ->region, administrator ->, language fornon unicode, which unfortunately does not exist in older Windows updates.

Correct answer by sep7696 on August 16, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP