As far as I remember there is a limit of 4000 bytes per record

Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT
 
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
 
Tel     +45 6311 4900
Direct  +45 6311 4908
Mob     +45 5156 1045
Fax     +45 6311 4949
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk/gis

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nabors, Steve
Sent: Monday, January 23, 2006 3:13 PM
To: Paul Middleton
Cc: [email protected]
Subject: RE: [MI-L] Number of fields

There may be an actual field number limit but I've found in my experience that 
the real limiting factor is more of how long the combined field names length 
is.  That is what I have found to be my limiting factor

Example:

sCombinedFieldCharacterlength = LongFieldname1 + Longfieldname2 +
Longfieldname3 + LongfieldnameN.....

Once you add up the combined character length of these fields, and if you keep 
adding long field named fields, you will hit a limit to where you can no longer 
create the table. 

I cant remember what the actual character length is but I'll look back into my 
notes and let you know.


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Middleton
Sent: Sunday, January 22, 2006 7:48 PM
To: [email protected]
Subject: [MI-L] Number of fields

Hi all,
What is the limitations on the number of fields you can have in any one 
layer/table, if so what are they and does the version of MI make any difference.
Regards
Paul Middleton
GIS Manager
Eurobodalla Shire Council
PO Box 99, Moruya NSW, 2537 Australia
URL: http://www.esc.nsw.gov.au <http://www.esc.nsw.gov.au> Phone (02) 44741270 
Fax (02) 44741234 _______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l




______________________________________________________________________
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l



_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to