thanks. how can you tell? On Dec 13, 2007 6:17 PM, Tom Glancy <[EMAIL PROTECTED]> wrote:
> Your dbf file contains spaces (0x20) in the "microrelie" boolean and > "macrorelie" boolean fields. The representation of NULL in boolean fields is > a question mark (0x3f). Allowable characters in a boolean field are > Y,y,N,n,T,t,F,f,? > > It looks like your dbf is broken. > > Regards, > Tom > > > >>> "Willy-Bas Loos" <[EMAIL PROTECTED]> 12/13/2007 6:15 AM >>> > > here's the rest of the shapefile (still one record, attached). > > On Dec 13, 2007 11:04 AM, Willy-Bas Loos <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > I have a small problem wit shp2pgsql, it doesn't convert my colleague's > > shapefile correctly. > > I've attached the 1rec shapefile and the shp2pgsql result in this mail, > > hope that works. > > > > I'm using this version: RCSID: $Id: shp2pgsql.c,v 1.88.2.7 2005/08/29 > > 22:36:14 strk Exp $ > > on windows XP. > > > > The problem is in two of the boolean fields: "microrelie" boolean and > > "macrorelie" boolean. > > They are both created, but their values don't make it into the INSERT > > statement. They turn up as empty strings, which is illegal SQL. > > There are lots (37) of fields in the shapefile. > > 12 other boolean fields are handled correctly. > > The "bad" fields are the 24th and the 25th field. > > > > is this some bug? > > > > WBL > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
