DBF DataTypes:
From the VFP help topic Data and Field Types
From the VFP help topic Data and Field Types
| Data type | Description | Size (bytes) | Range |
|---|---|---|---|
| Character | Any text | 1 to 254 | Any characters |
 Varchar | Any text | 1 to 254 | Any characters |
| Varbinary | Binary data | 1 to 254 | Binary data |
| Date | Chronological data consisting of month, year, and day | 8 | When using strict date formats, {^0001-01-01}, January 1st, 1 A.D to {^9999-12-31}, December 31st, 9999 A.D. |
| Date Time | Chronological data consisting of month, year, day, and time | 8 | {^0001-01-01}, January 1st, 1 A.D to {^9999-12-31}, December 31st, 9999 A.D., plus 00:00:00 a.m. to 11:59:59 p.m. |
| Numeric | Integers or fractions | 1 to 20 | - .9999999999E+19 to .9999999999E+20 |
| Float | Integers or fractions | 1 to 20 | - .9999999999E+19 to .9999999999E+20 |
| Integer | Integers | 4 | -2,147,483,647 to 2,147,483,647 |
| Double | 1 to 20 | - .9999999999E+19 to .9999999999E+20 | |
| Currency | Monetary amounts | 8 bytes | - 922337203685477.5807 to 922337203685477.5807 |
| Logical | Boolean value of true or false | 1 byte | True (.T.) or False (.F.) |
| Memo | Any text | In the DBF 4 bytes/memo In the FPT allocated in chuncks based on SET BLOCKSIZE | Any characters |
| General | data and host program | In the DBF 4 bytes/memo In the FPT allocated in chuncks based on SET BLOCKSIZE | OLE Documents |
| Blob | Binary data | In the DBF 4 bytes/memo In the FPT allocated in chuncks based on SET BLOCKSIZE | Binary data |
0 意見:
張貼留言