Visual FoxPro OLE DB Provider Data Support

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_DECIMAL
Float	F	1 to 20 bytes	- .9999999999E+19 to .9999999999E+20	DBTYPE_DECIMAL
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:

See Also