InnoDB compares CHAR and VARCHAR strings of different lengths such that the remaining length in the shorter string is treated as if padded with spaces. 没有看懂手册里面这句话的含义,单个单词都知道意思,整合在一起理解不了。
调试欢乐多
则innodb比较这两个类型的字符串的话 则是'a '和'ab'比较
InnoDB compares CHAR and VARCHAR strings of different lengths//
such that //
the remaining length in the shorter string //
is treated as if padded with spaces.