Mybatis Oracle field is defined as char

One of my friends asked me on wechat, “If JavaType String is not available, int can be used. Have you ever encountered it?

I really haven’t.

The oracle char type does not contain enough bits

For example, we define char(2)

Char = ‘1’

At this point, navicat uses data for both char = ‘1’ and char = 1, and of course char = ‘1’ also works

However, mybatis does not allow String Character

The solution found

1. Trim (char) = ‘1

2. Honestly change the type to varchar2

My friend, hehe hehe