DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADO Datatype Enums

94640Nov 3 2003 — edited Nov 12 2003

Hi,

Does anyone know the list of ADO Datatype Enums for the Oracle9i Database datatypes?

I produced this list by populating a table with all the column types, but think the NCHAR and NVARCHAR should be mapped to adWChar,adVarWChar did I do something wrong?

Datatype Enum ADO Datatype Enum
BFILE 205 adLongVarBinary
BLOB 205 adLongVarBinary
CHAR 129 adChar
CLOB 201 adLongVarChar
DATE 135 adDBTimeStamp
LONG 201 adLongVarChar
LONG RAW 205 adLongVarBinary
NCHAR 129 adChar
NCLOB 201 adLongVarChar
NUMBER 131 adNumeric
NVARCHAR2 200 adVarChar
RAW 204 adVarBinary
VARCHAR2 200 adVarChar
FLOAT 5 adDouble
DOUBLE PRECISION 5 adDouble
REAL 5 adDouble

Thanks,
Niall

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2003

Added on Nov 3 2003

#oracle-provider-for-ole-db, #windows-and-net

1 comment

1,431 views