Postgres Pro
Downloads
Home   >   mailing lists

BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf - Mailing list pgsql-bugs

From francois.bonzon@gmail.com
Subject BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf
Date
Msg-id E1TdwjQ-0000Nh-Mp@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: jackie.qq.zhang@gmail.com
Date:
Subject: BUG #7713: Is it a good idea to write more?
Next
From: claudiob_br@yahoo.com.br
Date:
Subject: BUG #7714: Error Message related to "sql_implementation_info" when itś not part of the query...