paschim Posted September 2, 2008 Share Posted September 2, 2008 Well, i don't know if this is supposed to happen or there is a mistake somewhere, but say i try to run a query where name='zoro', it returns rows for zoro, Zoro, zOro,.... any idea whats happening? I can obviously run a check in later part of code....but isn't there any way to just return rows for exactly that particular name? i mean case-sensitive search? Quote Link to comment Share on other sites More sharing options...
tmbrown Posted September 3, 2008 Share Posted September 3, 2008 im not entirely sure how you would do this. however if it is a username and password, require that the username matches with its password, or use the same technique within other fields. usually unique id's take care of this problem. howver i cant really say ive had a problem with case sensitivity before. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 3, 2008 Share Posted September 3, 2008 http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html Quote Link to comment Share on other sites More sharing options...
fenway Posted September 3, 2008 Share Posted September 3, 2008 Alternatively, use a collation that is case sensitive. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.