MyBatis中jdbcType和Oracle以及MySql数据类型对应关系表

桃扇骨 2023-06-25 06:06 8阅读 0赞

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <th>Mybatis</th> 
   <th>JdbcType</th> 
   <th>Oracle</th> 
   <th>MySql</th> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>ARRAY</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>BIGINT</td> 
   <td>&nbsp;</td> 
   <td>BIGINT</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>BINARY</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>BIT</td> 
   <td>&nbsp;</td> 
   <td>BIT</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>BLOB</td> 
   <td>BLOB</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>BOOLEAN</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>CHAR</td> 
   <td>CHAR</td> 
   <td>CHAR</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>CLOB</td> 
   <td>CLOB</td> 
   <td>CLOB–&gt;修改为TEXT</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>CURSOR</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>DATE</td> 
   <td>DATE</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>DECIMAL</td> 
   <td>DECIMAL</td> 
   <td>DECIMAL</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>DOUBLE</td> 
   <td>NUMBER</td> 
   <td>DOUBLE</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>FLOAT</td> 
   <td>FLOAT</td> 
   <td>FLOAT</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>INTEGER</td> 
   <td>INTEGER</td> 
   <td>INTEGER</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>LONGVARBINARY</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>LONGVARCHAR</td> 
   <td>LONG VARCHAR</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>NCHAR</td> 
   <td>NCHAR</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>NCLOB</td> 
   <td>NCLOB</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>dbcType</td> 
   <td>NUMERIC</td> 
   <td>NUMERIC/NUMBER</td> 
   <td>NUMERIC/</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>NVARCHAR</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>OTHER</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>REAL</td> 
   <td>REAL</td> 
   <td>REAL</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>SMALLINT</td> 
   <td>SMALLINT</td> 
   <td>SMALLINT</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>STRUCT</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>TIME</td> 
   <td>&nbsp;</td> 
   <td>TIME</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>TIMESTAMP</td> 
   <td>TIMESTAMP</td> 
   <td>TIMESTAMP/DATETIME</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>TINYINT</td> 
   <td>&nbsp;</td> 
   <td>TINYINT</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>UNDEFINED</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>VARBINARY</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>JdbcType</td> 
   <td>VARCHAR</td> 
   <td>VARCHAR</td> 
   <td>VARCHAR</td> 
  </tr> 
 </tbody> 
</table>