Mysql中char和varchar的区别（转载）

关于评论区

我：语句中like后的’ ‘不会省 是什么意思啊，like后的’ '中不是放%和_通配符的吗，我表示不懂，能解答下吗？另外说一句，这是我翻阅各大博客平台觉得最好的文章。

作者：like中可以放通配符，也可以放具体的字段，这个的 ’ ’ 表示一个空格，当空格在前面时必须考虑，不会省略，就是不会把 ‘空格OK’ 当成 ‘OK’，但是空格在末尾省略，也就是说会把 ‘OK空格’ 当成 ‘OK’

我：也就是说通过like模糊查询OK，char会得到空格OK，varchar会得到空格OK空格。

链接地址《Mysql中char和varchar的区别》
的思考，见如下图片：

like模糊查询的时候，首先首部空格一定要包括，其次不能视尾部空格不存在来查了（varchar情况 - s2），那个where子句查询可以：

mysql> select * from diff where s1 = 'OK ';
Empty set

mysql> select * from diff where s2 = 'OK ';
Empty set

mysql> select * from diff where s1 = ' OK ';
+----+-----+------+
| id | s1  | s2   |
+----+-----+------+
|  3 |  OK |  OK  |
+----+-----+------+
1 row in set (0.05 sec)

mysql> select * from diff where s2 = ' OK ';
+----+-----+------+
| id | s1  | s2   |
+----+-----+------+
|  3 |  OK |  OK  |
+----+-----+------+
1 row in set (0.05 sec)

mysql> select * from diff where s1 = ' OK';
+----+-----+------+
| id | s1  | s2   |
+----+-----+------+
|  3 |  OK |  OK  |
+----+-----+------+
1 row in set (0.05 sec)

mysql> select * from diff where s2 = ' OK';
+----+-----+------+
| id | s1  | s2   |
+----+-----+------+
|  3 |  OK |  OK  |
+----+-----+------+
1 row in set (0.04 sec)