Thread: BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf

The following bug has been logged on the website:

Bug reference:      7712
Logged by:          Fran=C3=A7ois Bonzon
Email address:      francois.bonzon@gmail.com
PostgreSQL version: 9.2.1
Operating system:   Ubuntu 12.04
Description:        =


This header is an optional feature of .DBF files to specify the character
encoding of its text attributes (UTF-8, CP1251, etc.). So is a .cpg sibling
file, that can carry the same information, and an alternate way to store
this information, that many GIS software support.

The dumper tool pgsql2shp should set this header, as PostreSQL knowns what
encoding it is writing to.

Some popular tools (including OGR library, QGIS) are mis-interpreting the
encoding of a shapefile that is missing this header.

Hello Francois,

On 11/29/2012 06:32 AM, francois.bonzon@gmail.com wrote:
> The dumper tool pgsql2shp should set this header, as PostreSQL knowns what
> encoding it is writing to.

I think that belongs to the separate PostGIS project. Please find their
issue tracker here:

  http://trac.osgeo.org/postgis/

Regards

Markus Wanner