[postgis-users] pgsql2shp dbf file encoding

[Denis Rykov]

After editing dbf file in hex editor and set value at byte 29 to 00h
shapefile opens in ArcGIS without
encoding troubles (get codepage value from *.cpg file).

On Tue, Oct 26, 2010 at 12:30 AM, Paul Ramsey <pramsey at opengeo.org> wrote:

> Can you hexedit it and see if it works better?
>
> On Mon, Oct 25, 2010 at 10:25 AM, Denis Rykov <rykovd at gmail.com> wrote:
> > Will it make sense to set 0 as a default? In the current case some
> software
> > (ArcGIS) does not override correct CPG setting with obviously incorrect
> 1252
> > from the header.
> >
> > On Tue, Oct 26, 2010 at 12:03 AM, Paul Ramsey <pramsey at opengeo.org>
> wrote:
> >>
> >> And that DBF field dates from the Time Before UTF-8, so there won't be
> >> a "UTF8" number to put in it, in any event.  DBF files with UTF in
> >> them (OSM!) are scary scary scary (for example, should your code for
> >> reading a CHAR(8) field in DBF expect 8 bytes, or 8 characters? yay!)
> >> It would be nice to support transcoding down to the code pages that
> >> *are* supported in that field, I suppose. I wonder how much software
> >> actually supports it.
> >>
> >> P.
> >>
> >> On Mon, Oct 25, 2010 at 9:57 AM, Mark Cave-Ayland
> >> <mark.cave-ayland at siriusit.co.uk> wrote:
> >> > Denis Rykov wrote:
> >> >
> >> >> 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
> >> >
> >> > Well pgsql2shp has never contained any code to set the encoding field
> >> > (mainly because until recently the version of shapelib included with
> >> > PostGIS
> >> > didn't support the encoding field), so I guess WIN1252 must be the
> >> > shapelib
> >> > default.
> >> >
> >> >
> >> > 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
> >
> >
> > _______________________________________________
> > 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/20101026/46ef02c8/attachment.html>