ADO Data Types
The table below shows the ADO Data Type mapping between Access, SQL Server, and Oracle:
| DataType Enum |
Value |
Access |
SQLServer |
Oracle |
| adBigInt |
20 |
|
BigInt (SQL Server 2000 +) |
|
| adBinary |
128 |
|
Binary
TimeStamp |
Raw * |
| adBoolean |
11 |
YesNo |
Bit |
|
| adChar |
129 |
|
Char |
Char |
| adCurrency |
6 |
Currency |
Money
SmallMoney |
|
| adDate |
7 |
Date |
DateTime |
|
| adDBTimeStamp |
135 |
DateTime (Access 97 (ODBC)) |
DateTime
SmallDateTime |
Date |
| adDecimal |
14 |
|
|
Decimal * |
| adDouble |
5 |
Double |
Float |
Float |
| adGUID |
72 |
ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB)) |
UniqueIdentifier (SQL Server 7.0 +) |
|
| adIDispatch |
9 |
|
|
|
| adInteger |
3 |
AutoNumber
Integer
Long |
Identity (SQL Server 6.5)
Int
|
Int * |
| adLongVarBinary |
205 |
OLEObject |
Image |
Long Raw *
Blob (Oracle 8.1.x) |
| adLongVarChar |
201 |
Memo (Access 97)
Hyperlink (Access 97) |
Text |
Long *
Clob (Oracle 8.1.x) |
| adLongVarWChar |
203 |
Memo (Access 2000 (OLEDB))
Hyperlink (Access 2000 (OLEDB)) |
NText (SQL Server 7.0 +) |
NClob (Oracle 8.1.x) |
| adNumeric |
131 |
Decimal (Access 2000 (OLEDB)) |
Decimal
Numeric |
Decimal
Integer
Number
SmallInt |
| adSingle |
4 |
Single |
Real |
|
| adSmallInt |
2 |
Integer |
SmallInt |
|
| adUnsignedTinyInt |
17 |
Byte |
TinyInt |
|
| adVarBinary |
204 |
ReplicationID (Access 97) |
VarBinary |
|
| adVarChar |
200 |
Text (Access 97) |
VarChar |
VarChar |
| adVariant |
12 |
|
Sql_Variant (SQL Server 2000 +) |
VarChar2 |
| adVarWChar |
202 |
Text (Access 2000 (OLEDB)) |
NVarChar (SQL Server 7.0 +) |
NVarChar2 |
| adWChar |
130 |
|
NChar (SQL Server 7.0 +) |
|
* In Oracle 8.0.x - decimal and int are equal to number and number(10).
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
|
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
|
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Promote collaboration among coworkers in your organization through project workspaces where others can efficiently find information and work together |
|
Personalize your company profile by bookmarking and organizing favorite content, uploading assets, posting photos, blogging, and more |
|
Interact with features like tagging, flagging, wikis and ratings found in the Web 2.0 Toolbox |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an
INSTANT DEMO or download a
FREE TRIAL today. |
|
HOME
Printer friendly page
