[Qgis-user] shapefile/dbf number limitation?

[Zirneklitis]

You can't use REAL field type for ID as it a bit approximately, e.g., 
number '1234567890123456789' will memorised as '1,23456789012347E+018'.
The INTEGER should be used instead. You have already hit the limitations 
for INTEGER as only 4 bytes are used (-2147483648 .. 2147483647).

Best regards,
Karlis

Christine wrote:
> We also had a problem these days with a shapefile in QGIS. A field of this
> shapefile was defined with REAL; length 19 and precision 0, just at the
> limits Zirneklitis wrote about [On Apr 20, 2012, at 2:29 AM]:
> ........
>> It's against SHP specification. The maximum precision of number field is
>> 18 (with scale>  0, scale max = 17) or 19 (with scale = 0 ).
> ........
>
> The field contained an object_id. An attempt to save/export selected
> features of the shapefile let all the object_id fields be filled with
> -2147483648 values.
> ..