MDAC 2.5 SDK - Visual FoxPro ODBC Driver
The following table lists the values for the FieldType argument in ALTER TABLE and CREATE TABLE and indicates whether nFieldWidth and nPrecision arguments are required.
| FieldType | NFieldWidth | nPrecision | Description |
| B | - | d | Double |
| C | N | - | Character field of width n |
| D | - | - | Date |
| F | N | d | Floating numeric field of width n with d decimal places |
| G | - | - | General |
| I | - | - | Integer |
| L | - | - | Logical |
| M | - | - | Memo |
| N | N | d | Numeric field of width n with d decimal places |
| T | - | - | DateTime |
| Y | - | - | Currency |