1. character(10):最大长度10,不足10则补空格。
select * from test where address='a ';
--or
select * from test where address='a';
2. character varing(10):最大长度10,不足则为字符长度。
select * from test where address='a';
3. character varing:长度没有限制。
select * from test where address='a';