[postgis-users] Size of FTDate field in dbf files

[Paul Ramsey]

Patch applied in svn. Everyone else creating dated dbf files, keep an
eye on them! It's not obvious why the original was written at 10 wide.

On Thu, Apr 10, 2008 at 3:29 AM, Peter Hopfgartner
<peter.hopfgartner at r3-gis.com> wrote:
> Dear PostGIS developers
>
>  After having changed the field size from 10 to 8 everything works fine as
> expected.
>
>  This means that the comment in file pgsql2shp.c, lines 2730,2731 is not
> accurate anymore.
>
>
>  The attached diff is against the current SVN.
>
>
>  Best regards,
>
>  Peter Hopfgartner and Sergio Segala
>  R3 GIS
>
>  http://www.r3-gis.com
>
>
>
>  Peter Hopfgartner wrote:
>
> > Dear mailing list members,
> >
> > we had some problems when editing shape files containing dates generated
> with pgsql2shp. In particular, editing these files with ArcGIS and some OS
> desptop GIS (QGIS or OpenJump, sorry I can't remember exactly) the
> attributes where shifted by some white spaces.
> >
> > Looking at the files generated with pgsql2shp, we noted that  a length of
> 10 bytes is assigned to date fields (see also current the svn snapshot,
> loader/pgsql2shp.c:2735,2736), in apparent contrast with the dbf file format
> specification (http://www.dbase.com/knowledgebase/int/db7_file_fmt.htm),
> which specifies that these field are 8 bytes long.
> >
> > Best regards,
> >
> > Peter Hopfgartner and Sergio Segala
> > R3 GIS
> >
> > http://www.r3-gis.com
> > _______________________________________________
> > 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
>
>