Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2003
Added on Nov 3 2003
1 comment
1,431 views