FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Is it possible to create DBF field_name > 10 chars ?
Posts: 76
Joined: Wed Oct 12, 2005 05:52 PM
Is it possible to create DBF field_name > 10 chars ?
Posted: Wed Jan 25, 2006 12:40 PM

Hi, i need to import data from other Database like MySql .
Is it possible to create dbf file with field_name > 10 chars ?

Tks

Posts: 207
Joined: Fri Oct 07, 2005 07:58 AM
Is it possible to create DBF field_name > 10 chars ?
Posted: Wed Jan 25, 2006 02:48 PM
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
ยฉ I'm not patented!

Continue the discussion