[Qgis-user] shapefile/dbf number limitation?

[Giovanni Manghi]

Hi,

> 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. 
> 
> Did some testing with that field definition (Real, length 19, precision 0)
> and only the range of values between 2147483647 and -2147483648 seems to be
> insertable. Beyond that, -2147483648 appears in the fields after saving the
> table. The object_id in the original shapefile exceeded the mentioned value
> range. 


that range is the one for int4 column types, see for example

http://www.postgresql.org/docs/9.1/static/datatype-numeric.html

can the dbf format store numbers outside this range?

Please see also

http://hub.qgis.org/issues/5546

add your notes and eventually suggest a new title/description.

Cheers

-- Giovanni --