anu123 Posted December 17, 2009 Share Posted December 17, 2009 Hi I need to make a field, for example the 'username' field in my 'users' table to be case insensitive. Is there any function or something of that sort to make the field case insensitive.Can anyone help me with a solution. Thank you in advance Quote Link to comment https://forums.phpfreaks.com/topic/185441-case-insensitive-data/ Share on other sites More sharing options...
trq Posted December 17, 2009 Share Posted December 17, 2009 Use strtolower when storing and searching. Quote Link to comment https://forums.phpfreaks.com/topic/185441-case-insensitive-data/#findComment-979066 Share on other sites More sharing options...
fenway Posted December 18, 2009 Share Posted December 18, 2009 Hold on -- by default, all columns are case insensitive.... Quote Link to comment https://forums.phpfreaks.com/topic/185441-case-insensitive-data/#findComment-979583 Share on other sites More sharing options...
anu123 Posted December 18, 2009 Author Share Posted December 18, 2009 Thank you for your reply, i was actually using the BINARY in my queries, so it overwrote the default case insensitivity...Thanks to correct me with the clue. Quote Link to comment https://forums.phpfreaks.com/topic/185441-case-insensitive-data/#findComment-979643 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.