pdkv2 Posted January 22, 2008 Share Posted January 22, 2008 Hi all How can i make the case sensitive search in my query given below 1.SELECT COUNT(*) as count FROM country_list WHERE country='india'; 2.SELECT COUNT(*) as count FROM country_list WHERE country='India'; Both the sql gives same output(on windows and unix) i am using mysql 5.0 Regards Sharad Quote Link to comment Share on other sites More sharing options...
beebum Posted January 22, 2008 Share Posted January 22, 2008 Try this: SELECT COUNT(*) as count FROM country_list WHERE country='India' COLLATE latin1_bin; Quote Link to comment Share on other sites More sharing options...
pdkv2 Posted January 23, 2008 Author Share Posted January 23, 2008 Thank you very much !! 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.