Provider Information FoxPro Column Type Information: I (Integer) (I4) (size 10) (isfixedlength) (best) F (Float) (NUMERIC) (size 20) (isfixedlength) (width, decimal places) (best) N (Numeric) (NUMERIC) (size 20) (isfixedlength) (width, decimal places) B (Double) (R8) (size 15) (isfixedlength) (decimal places) (best) Y (Currency) (CY) (size 19) (isfixedlength) (best) D (Date) (DATE) (size 10) (isfixedlength) (best) D (Date) (DBDATE) (size 10) (isfixedlength) (best) T (DateTime) (DBTIMESTAMP) (size 19) (isfixedlength) (best) L (Logical) (BOOL) (size 1) (isfixedlength) (best) G (General) (BYTES) (size 2147483647) (islong) M (Memo) (STR) (size 2147483647) (islong) C (Character) (STR) (size 254) (isfixedlength) (length) V (Varchar) (STR) (size 254) (max length) (best) W (Blob) (BYTES) (size 2147483647) (islong) Q (Varbinary) (BYTES) (size 254) (max length) (best) Int (Integer) (I4) (size 10) (isfixedlength) (best) Integer (I4) (size 10) (isfixedlength) (best) Float (NUMERIC) (size 20) (isfixedlength) (width, decimal places) (best) Num (Numeric) (NUMERIC) (size 20) (isfixedlength) (width, decimal places) Numeric (NUMERIC) (size 20) (isfixedlength) (width, decimal places) Double (R8) (size 15) (isfixedlength) (decimal places) (best) Currency (CY) (size 19) (isfixedlength) (best) Date (DATE) (size 10) (isfixedlength) (best) Date (DBDATE) (size 10) (isfixedlength) (best) DateTime (DBTIMESTAMP) (size 19) (isfixedlength) (best) Logical (BOOL) (size 1) (isfixedlength) (best) General (BYTES) (size 2147483647) (islong) Memo (STR) (size 2147483647) (islong) Char (Character) (STR) (size 254) (isfixedlength) (length) Character (STR) (size 254) (isfixedlength) (length) Varchar (STR) (size 254) (max length) (best) Blob (BYTES) (size 2147483647) (islong) Varbinary (BYTES) (size 254) (max length) (best) This list can be created for any initialized provider, by choosing [Admin/DBMS data types] and copying from the Results tab.