mysql where条件中 字符串右边的空格会忽略

mysql where条件中 字符串右边的空格会忽略

 All MySQL collations are of type PADSPACE. This means that all CHAR, VARCHAR, and TEXT values in MySQL are compared without regard to any trailing spaces. “Comparison” in this context does not include the LIKE pattern-matching operator, for which trailing spaces are significant. 

mysql> select * from test where name='aa ';

+------+------+

| id   | name |

+------+------+

|    1 | aa   |

|    2 | aa   |

+------+------+

加上binary可以避免这个问题

mysql> select * from test where name= binary 'aa ';

+------+------+

| id   | name |

+------+------+

|    1 | aa   |

+------+------+

1 row in set (0.00 sec)

转载请注明源出处 
QQ 273002188 欢迎一起学习 
QQ 群 236941212 
oracle,mysql,mongo 相互交流

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-1867511/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-1867511/