MySQL Forums
Forum List  »  Chinese

字符比較問題求解
Posted by: li gang
Date: August 18, 2011 03:09AM

注意後面有個空格
在mysql5.0.22版本中
select customeri from inv_h where customeri>='RJGCB '
可以查出RJGCB

但在5.1.47版本中
同樣的命令卻查不出,要去空格才行,也就是改為 customeri>='RJGCB'

請問高手這是為什麼?,要如何設置my.cnf文件呢?

Options: ReplyQuote


Subject
Views
Written By
Posted
字符比較問題求解
6559
August 18, 2011 03:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.