Oracle和sqlserver数据类型对应关系大全

骑猪看日落 2023-10-08 09:34 8阅读 0赞

<table> 
 <thead> 
  <tr> 
   <th>SQL Server 数据类型</th> 
   <th>Oracle 数据类型</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>bigint</td> 
   <td>NUMBER(19,0)</td> 
  </tr> 
  <tr> 
   <td>binary(1-2000)</td> 
   <td>RAW(1-2000)</td> 
  </tr> 
  <tr> 
   <td>binary(2001-8000)</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>bit</td> 
   <td>NUMBER(1)</td> 
  </tr> 
  <tr> 
   <td>char(1-2000)</td> 
   <td>CHAR(1-2000)</td> 
  </tr> 
  <tr> 
   <td>char(2001-4000)</td> 
   <td>VARCHAR2(2001-4000)</td> 
  </tr> 
  <tr> 
   <td>char(4001-8000)</td> 
   <td>CLOB</td> 
  </tr> 
  <tr> 
   <td>date</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>datetime</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>datetime2(0-7)</td> 
   <td>TIMESTAMP(7)（对于 Oracle 9 和 Oracle 10）；VARCHAR(27)（对于 Oracle 8）</td> 
  </tr> 
  <tr> 
   <td>datetimeoffset(0-7)</td> 
   <td>TIMESTAMP(7) WITH TIME ZONE（对于 Oracle 9 和 Oracle 10）；VARCHAR(34)（对于 Oracle 8）</td> 
  </tr> 
  <tr> 
   <td>decimal(1-38, 0-38)</td> 
   <td>NUMBER(1-38, 0-38)</td> 
  </tr> 
  <tr> 
   <td>float(53)</td> 
   <td>FLOAT</td> 
  </tr> 
  <tr> 
   <td>float</td> 
   <td>FLOAT</td> 
  </tr> 
  <tr> 
   <td>地理</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>geometry</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>hierarchyid</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>图像</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>NUMBER(10,0)</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>NUMBER(19,4)</td> 
  </tr> 
  <tr> 
   <td>nchar(1-1000)</td> 
   <td>CHAR(1-1000)</td> 
  </tr> 
  <tr> 
   <td>nchar(1001-4000)</td> 
   <td>NCLOB</td> 
  </tr> 
  <tr> 
   <td>ntext</td> 
   <td>NCLOB</td> 
  </tr> 
  <tr> 
   <td>numeric(1-38, 0-38)</td> 
   <td>NUMBER(1-38, 0-38)</td> 
  </tr> 
  <tr> 
   <td>nvarchar(1-1000)</td> 
   <td>VARCHAR2(1-2000)</td> 
  </tr> 
  <tr> 
   <td>nvarchar(1001-4000)</td> 
   <td>NCLOB</td> 
  </tr> 
  <tr> 
   <td>nvarchar(max)</td> 
   <td>NCLOB</td> 
  </tr> 
  <tr> 
   <td>real</td> 
   <td>real</td> 
  </tr> 
  <tr> 
   <td>smalldatetime</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>NUMBER(5,0)</td> 
  </tr> 
  <tr> 
   <td>smallmoney</td> 
   <td>NUMBER(10,4)</td> 
  </tr> 
  <tr> 
   <td>sql_variant</td> 
   <td>N/A</td> 
  </tr> 
  <tr> 
   <td>sysname</td> 
   <td>VARCHAR2(128)</td> 
  </tr> 
  <tr> 
   <td>text</td> 
   <td>CLOB</td> 
  </tr> 
  <tr> 
   <td>time(0-7)</td> 
   <td>VARCHAR(16)</td> 
  </tr> 
  <tr> 
   <td>timestamp</td> 
   <td>RAW(8)</td> 
  </tr> 
  <tr> 
   <td>tinyint</td> 
   <td>NUMBER(3,0)</td> 
  </tr> 
  <tr> 
   <td>uniqueidentifier</td> 
   <td>CHAR(38)</td> 
  </tr> 
  <tr> 
   <td>varbinary(1-2000)</td> 
   <td>RAW(1-2000)</td> 
  </tr> 
  <tr> 
   <td>varbinary(2001-8000)</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>varchar(1-4000)</td> 
   <td>VARCHAR2(1-4000)</td> 
  </tr> 
  <tr> 
   <td>varchar(4001-8000)</td> 
   <td>CLOB</td> 
  </tr> 
  <tr> 
   <td>varbinary(max)</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>varchar(max)</td> 
   <td>CLOB</td> 
  </tr> 
  <tr> 
   <td>xml</td> 
   <td>NCLOB</td> 
  </tr> 
 </tbody> 
</table>