Page 1 of 1

Is it possible to create DBF field_name > 10 chars ?

PostPosted: Wed Jan 25, 2006 12:40 pm
by Piscicelli Zingoni
Hi, i need to import data from other Database like MySql .
Is it possible to create dbf file with field_name > 10 chars ?

Tks

PostPosted: Wed Jan 25, 2006 2:48 pm
by modicr
Hello!

The maximum DBF field name length is 10 bytes and may only contain the letters ‘a’-‘z’ and ‘A’-‘Z’, digits ‘0’-‘9’, and the underscore ‘_’ character. The maximum number of records in a DBF table is 2 billion.


BTW, you can use Advantage ADT format instead of DBF ...
The Advantage Database Server supports a proprietary ADT table. The maximum ADT field name length is 128 bytes and may contain any character value except 0 (NULL), ';' (a semi-colon), or ',' (a comma).


Regards, Roman