[postgis-users] pgsql2shp dbf file encoding

[Denis Rykov]

I don't quite understand why pgsql2shp is writing this encoding to our
shapes, our database is in UTF-8 and we never use win1252

On Mon, Oct 25, 2010 at 5:42 PM, Francis Markham <fmarkham at gmail.com> wrote:

> 0x57h is the dreaded Windows-1252 codepage.  I believe new versions of
> shapelib allow this to be set when the shapefile is created.
>
> Cheers,
>
> Francis Markham
>
>
> On 25 October 2010 20:05, Mark Cave-Ayland
> <mark.cave-ayland at siriusit.co.uk> wrote:
> >
> > Denis Rykov wrote:
> >
> >> Try to export postgis data to shapefiles with pgsql2shp
> (pgsql2shp-core.h 5870 2010-08-28 09:16:32Z mcayland)
> >> If open *.dbf file I see the value in my dbf files at byte 29 is 0x57h.
> Is the 0x57h value is default? Why not 0x00h?
> >> With 0x57h encoding my shapefiles looks not correct in any GIS software.
> >
> > I don't think it's currently set to anything, so I guess this would be
> the default? Perhaps we should provide a mapping from PostgreSQL database
> encoding names to shapefile encoding values in a table somewhere?
> >
> > Anyone know which encoding 0x57h represents?
> >
> >
> > ATB,
> >
> > Mark.
> >
> > --
> > Mark Cave-Ayland - Senior Technical Architect
> > PostgreSQL - PostGIS
> > Sirius Corporation plc - control through freedom
> > http://www.siriusit.co.uk
> > t: +44 870 608 0063
> >
> > Sirius Labs: http://www.siriusit.co.uk/labs
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101025/efcfe9b6/attachment.html>