Visual FoxPro OLE DB Provider Data Support

  • Article

The following table describes the types and other file and code characteristics of data supported by the Visual FoxPro OLE Db Provider.

Data type Indicator Size Range OLE DB type
Character C 1 byte per char to 254 Any Characters DBTYPE_STR
Character (binary) C NOCPTRANS 1 byte per char to 254 Any Characters DBTYPE_BYTES
Date D 8 bytes 0001-01-01 to 9999-12-31 DBTYPE_DATE
DateTime T 8 bytes 0001-01-01 to 9999-12-31; 00:00:00 a.m. to 11:59:59 p.m. DBTYPE_DBTIMESTAMP
Numeric N 1 to 20 bytes - .9999999999E+19 to .9999999999E+20 DBTYPE_NUMERIC
Float F 1 to 20 bytes - .9999999999E+19 to .9999999999E+20 DBTYPE_NUMERIC
Integer I 4 bytes 2147483647 to 2147483647 DBTYPE_I4
Double B 8 bytes +/-4.94065645841247E-324 to +/-8.9884656743115E307 DBTYPE_R8
Currency Y 8 bytes - 922337203685477.5807 to 922337203685477.5807 DBTYPE_CY
Logical L   .T./.F. DBTYPE_BOOL
Memo M 4 bytes in table Available memory DBTYPE_BYTES
Memo (binary) M NOCPTRANS 4 bytes in table Available memory DBTYPE_BYTES
General (blob) G 4 bytes in table Available memory DBTYPE_BYTES

The following table describes the mapping of Visual FoxPro OLE DB types to Visual Studio types:

Indicator OLE DB type Visual Studio type
C DBTYPE_STR System.String
C NOCPTRANS DBTYPE_BYTES System.String
D DBTYPE_DATE System.DateTime
T DBTYPE_DBTIMESTAMP System.DateTime
N DBTYPE_NUMERIC System.Decimal
F DBTYPE_NUMERIC System.Decimal
I DBTYPE_I4 System.Int32
B DBTYPE_R8 System.Double
Y DBTYPE_CY System.Decimal
M DBTYPE_STR System.String
M NOCPTRANS DBTYPE_BYTES System.Byte
G DBTYPE_BYTES System.Byte

See Also

Language Reference for OLE DB Development | Supported Visual FoxPro SET Commands | Supported Visual FoxPro Commands and Functions | Unsupported Visual FoxPro Commands and Functions | Supported OLE DB Objects | Standard and Custom OLE DB Properties | OLE DB Provider for Visual FoxPro