📄 ado_datatypes.asp@output=print
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ADO Data Types</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
<h1>ADO Data Types</h1>
<a href="ado_ref_stream.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_summary.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<hr />
<p>The table below shows the ADO Data Type mapping between Access, SQL Server, and Oracle:</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
<th width="20%" align="left" valign="top">DataType Enum</th>
<th width="10%" align="left" valign="top">Value</th>
<th width="23%" align="left" valign="top">Access</th>
<th width="23%" align="left" valign="top">SQLServer</th>
<th width="24%" align="left" valign="top">Oracle</th>
</tr>
<tr valign="top">
<td valign="top">adBigInt</td>
<td valign="top">20</td>
<td valign="top"> </td>
<td valign="top">BigInt (SQL Server 2000 +)</td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adBinary</td>
<td valign="top">128</td>
<td valign="top"> </td>
<td valign="top">Binary<br />
TimeStamp</td>
<td valign="top">Raw *</td>
</tr>
<tr>
<td valign="top">adBoolean</td>
<td valign="top">11</td>
<td valign="top">YesNo</td>
<td valign="top">Bit</td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top">adChar</td>
<td valign="top">129</td>
<td valign="top"> </td>
<td valign="top">Char</td>
<td valign="top">Char</td>
</tr>
<tr>
<td valign="top">adCurrency</td>
<td valign="top">6</td>
<td valign="top">Currency</td>
<td valign="top">Money<br />
SmallMoney</td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top">adDate</td>
<td valign="top">7</td>
<td valign="top">Date</td>
<td valign="top">DateTime</td>
<td valign="top"> </td>
</tr>
<tr>
<td valign="top">adDBTimeStamp</td>
<td valign="top">135</td>
<td valign="top">DateTime (Access 97 (ODBC))</td>
<td valign="top">DateTime<br />
SmallDateTime</td>
<td valign="top">Date</td>
</tr>
<tr>
<td valign="top">adDecimal</td>
<td valign="top">14</td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top">Decimal *</td>
</tr>
<tr>
<td valign="top">adDouble</td>
<td valign="top">5</td>
<td valign="top">Double</td>
<td valign="top">Float</td>
<td valign="top">Float</td>
</tr>
<tr valign="top">
<td valign="top">adGUID</td>
<td valign="top">72</td>
<td valign="top">ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))</td>
<td valign="top">UniqueIdentifier (SQL Server 7.0 +)</td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adIDispatch</td>
<td valign="top">9</td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adInteger</td>
<td valign="top">3</td>
<td valign="top">AutoNumber<br />
Integer<br />
Long</td>
<td valign="top">Identity (SQL Server 6.5)<br />
Int<br />
</td>
<td valign="top">Int *</td>
</tr>
<tr valign="top">
<td valign="top">adLongVarBinary</td>
<td valign="top">205</td>
<td valign="top">OLEObject</td>
<td valign="top">Image</td>
<td valign="top">Long Raw *<br />
Blob (Oracle 8.1.x)</td>
</tr>
<tr valign="top">
<td valign="top">adLongVarChar</td>
<td valign="top">201</td>
<td valign="top">Memo (Access 97)<br />
Hyperlink (Access 97)</td>
<td valign="top">Text</td>
<td valign="top">Long *<br />
Clob (Oracle 8.1.x)</td>
</tr>
<tr valign="top">
<td valign="top">adLongVarWChar</td>
<td valign="top">203</td>
<td valign="top">Memo (Access 2000 (OLEDB))<br />
Hyperlink (Access 2000 (OLEDB))</td>
<td valign="top">NText (SQL Server 7.0 +)</td>
<td valign="top">NClob (Oracle 8.1.x)</td>
</tr>
<tr valign="top">
<td valign="top">adNumeric</td>
<td valign="top">131</td>
<td valign="top">Decimal (Access 2000 (OLEDB))</td>
<td valign="top">Decimal<br />
Numeric</td>
<td valign="top">Decimal<br />
Integer<br />
Number<br />
SmallInt</td>
</tr>
<tr valign="top">
<td valign="top">adSingle</td>
<td valign="top">4</td>
<td valign="top">Single</td>
<td valign="top">Real</td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adSmallInt</td>
<td valign="top">2</td>
<td valign="top">Integer</td>
<td valign="top">SmallInt</td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adUnsignedTinyInt</td>
<td valign="top">17</td>
<td valign="top">Byte</td>
<td valign="top">TinyInt</td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adVarBinary</td>
<td valign="top">204</td>
<td valign="top">ReplicationID (Access 97)</td>
<td valign="top">VarBinary</td>
<td valign="top"> </td>
</tr>
<tr valign="top">
<td valign="top">adVarChar</td>
<td valign="top">200</td>
<td valign="top">Text (Access 97)</td>
<td valign="top">VarChar</td>
<td valign="top">VarChar</td>
</tr>
<tr valign="top">
<td valign="top">adVariant</td>
<td valign="top">12</td>
<td valign="top"> </td>
<td valign="top">Sql_Variant (SQL Server 2000 +)</td>
<td valign="top">VarChar2</td>
</tr>
<tr valign="top">
<td valign="top">adVarWChar</td>
<td valign="top">202</td>
<td valign="top">Text (Access 2000 (OLEDB))</td>
<td valign="top">NVarChar (SQL Server 7.0 +)</td>
<td valign="top">NVarChar2</td>
</tr>
<tr valign="top">
<td valign="top">adWChar</td>
<td valign="top">130</td>
<td valign="top"> </td>
<td valign="top">NChar (SQL Server 7.0 +)</td>
<td valign="top"> </td>
</tr>
</table>
<p>* In Oracle 8.0.x - decimal and int are equal to number and number(10).</p>
<hr />
<a href="ado_ref_stream.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_summary.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -