# DB2 Usage Notes

## LONG VARCHAR Fields

By default MyBatis Generator will map LONG VARCHAR fields to the `java.lang.String` data type, and will mark these fields as `jdbcType="LONGVARCHAR"`. This mapping will cause errors when retrieving data from DB2. DB2 LONG VARCHAR fields should be mapped to the `java.lang.String` data type with `jdbcType="VARCHAR"`. To overcome this problem, use a `<columnOverride>` as follows:

      <table schema="DB2ADMIN" tableName="ALLTYPES" >
        <columnOverride column="LONG_VARCHAR_FIELD" javaType="java.lang.String" jdbcType="VARCHAR" />
      </table>