Appendix C. Data Types, ADO Support and Error Messages The following sections describe the data types used with the OLE DB Provider, the ADO features implemented by the AS/400 OLE DB Provider, and error messages that are sent by the AS/400 OLE DB Provider. C.1 Data Types This section describes the data types that are used with the AS/400 OLE DB Provider. C.1.1 Table Data Types The following table indicates how the IBMDA400 provider maps AS/400 table data types to OLE DB data types: Table 57. AS/400 Data Type to OLE DB Data Type Cross-Reference AS/400 Table BINARY2 BINARY4 CHAR DATE EITHER FLTDBL FLTSNG GRAPHIC HEX ONLY OPEN PACKED TIME TIMESTAMP VARCHAR VAREITHER VARGRAPHIC VARHEX VARONLY VAROPEN ZONED OLE DB DBTYPE_I2 DBTYPE_I4 DBTYPE_STR DBTYPE_STR DBTYPE_STR DBTYPE_R8 DBTYPE_R4 DBTYPE_WSTR DBTYPE_BYTES DBTYPE_STR DBTYPE_STR DBTYPE_DECIMAL DBTYPE_STR DBTYPE_STR DBTYPE_STR DBTYPE_STR DBTYPE_WSTR DBTYPE_BYTES DBTYPE_STR DBTYPE_STR DBTYPE_NUMERIC Notes CHAR with CCSID 65535 is mapped to DBTYPE_BYTES VARCHAR with CCSID 65535 is mapped to DBTYPE_BYTES © Copyright IBM Corp. 1998 381