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

From: francois(dot)bonzon(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf
Date: 2012-11-29 05:32:16
Message-ID: E1TdwjQ-0000Nh-Mp@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7712
Logged by: François Bonzon
Email address: francois(dot)bonzon(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2012-11-29 05:35:05 Re: BUG #7711: Accessing nested composite types in PL/PgSQL doesn't work
Previous Message mkolomeitsev 2012-11-29 05:27:33 BUG #7711: Accessing nested composite types in PL/PgSQL doesn't work