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 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. 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.... 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. Link to comment https://forums.phpfreaks.com/topic/185441-case-insensitive-data/#findComment-979643 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.