[postgis-users] Length of Bigint, Double and Text fields

[Peter Hopfgartner]

Dear PostGIS devels,

since we right in the middle of comparing interoperability of shape 
files between some FOSS programs and ArcGIS, we encoutered also the 
following:

gvSIG chokes on the Bigint as produced by pgsql2shp. Looking at ArcGIs 
generated files, the max length for numbers is 19, compared to 20 for 
integers and 32 for floating points as in pgsql2shp. This seems to be 
confirmed by some Borland tools, when configured for dBase III+.

Another limit seems to be that of text fields, that must be no longer 
then 254. This is the maximum as given by ArcGIS and by the Borland tool.

Another point is Boolean: ArcGIS seems to not allow the creation of 
boolean fields and the Borland Tool ("Database Desktop") says that 
Booleans have a length of 1.

Regards,

Peter

-- 
 
Dott. Peter Hopfgartner
 
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: peter.hopfgartner at r3-gis.com
Tel. : +39 0473 494949
Fax  : +39 0473 069902
www  : http://www.r3-gis.com

================================================================================
Venite a trovarci all'ASITA, dal 1 al 4 dicembre a Bari www.asita.it
Besuchen Sie uns bei der Messe ASITA vom 1. bis 4. Dezember in Bari www.asita.it
Visit us at ASITA, from 1st to 4th December in Bari www.asita.it
================================================================================