mysql where條件中 字串右邊的空格會忽略

psufnxk2000發表於2015-12-07
MySql字串
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章