[fdo-dev] SHP provider

[Pierre Dalcourt]

Hi Haris,

 

Likely this is an issue with the SHP file you are using.  The DBF column
you are referring to seems to have a width of 19 and a scale of 11.  SHP
provider knocks 1 off the width when scale>0 (to make room for the '.'
decimal point character which is stored in the field), which is why you
get an FDO Precision of 18 instead of 19.  The important thing is that
in general the DBF scale is really more of a 'hint' than a hard fact
since some (many?) applications ignore the DBF scale and just put any
number that fits into the field's width (the width itself is a true hard
limit, unlike the scale).  SHP Provider will allow you to read such
values (that don't match the scale) in the interest of not
filtering/modifying the actual data in your SHP/DBF files.

 

Pierre

 

  _____  

From: Haris Kurtagic [mailto:haris at sl-king.com] 
Sent: November 10, 2006 5:11 AM
To: dev at fdo.osgeo.org
Subject: [fdo-dev] SHP provider

 

Hi,

 

SHP provider is reporting decimal data type column with Precision 18 and
Scale 11. Problem is that value in that column is with 9 digits on left
side of decimal point.

 

Is this a issue in provider or ?

 

Thank you,

Haris

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20061110/04ad5be4/attachment.html