日期:2014-05-16  浏览次数:20544 次

oralce, DB2 , sql server , mysql各数据库字段总结

<p style="text-align: center;"><strong><span style="font-size: large;"><span style="color: #ff0000;">oracle</span></span></strong></p>
<table class="MsoTableGrid" style="border-collapse: collapse;" border="1" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0cm; width: 85.2pt; padding-top: 0cm; border: windowtext 1pt solid;" width="114" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>数据类型</strong></span></p>
</td>
<td style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 85.2pt; padding-top: 0cm; border-bottom: windowtext 1pt solid;" width="114" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>取值范围</strong></span></p>
</td>
<td style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 168pt; padding-top: 0cm; border-bottom: windowtext 1pt solid;" width="224" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>描述</strong></span></p>
</td>
<td style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 87.7pt; padding-top: 0cm; border-bottom: windowtext 1pt solid;" width="117" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>备注</strong></span></p>
</td>
</tr>
<tr>
<td style="border-right: 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: 1pt solid; width: 85.2pt; padding-top: 0cm; border-bottom: 1pt solid;" width="114" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>Char(n)</strong></span></p>
</td>
<td style="border-right: 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 85.2pt; padding-top: 0cm; border-bottom: 1pt solid;" width="114" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>n=1 to 2000字节</strong></span></p>
</td>
<td style="border-right: 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 168pt; padding-top: 0cm; border-bottom: 1pt solid;" width="224" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>存储固定长度的字符串。默认长度为1。</strong></span></p>
</td>
<td style="border-right: 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 87.7pt; padding-top: 0cm; border-bottom: 1pt solid;" width="117" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>&nbsp;</strong></span></p>
</td>
</tr>
<tr>
<td style="border-right: 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: 1pt solid; width: 85.2pt; padding-top: 0cm; border-bottom: 1pt solid;" width="114" valign="top">
<p class="MsoNormal"><span style="font-size: small;"><strong>Varchar2(n)</strong></span></p>
</td>
<td style="border-right: 1pt