jackpf Posted April 24, 2009 Share Posted April 24, 2009 Good evening, I currently have a "users search" on my site, and my users column is varbinary, to obviously avoid the problem of case insensitive usernames. However, this results in the users search also being case sensitive. I use LIKE in my mysql query, which I thought would have done a case insensitive search, but apparently not. So yeah, just wondering if anyone knew how to perfom a case insensitive search on a varbinary column? Cheers, Jack. Quote Link to comment https://forums.phpfreaks.com/topic/155562-case-insensitive-varbinary/ Share on other sites More sharing options...
Mchl Posted April 24, 2009 Share Posted April 24, 2009 It's binary. It cannot be case sensitive by definition. http://dev.mysql.com/doc/refman/5.0/en/charset-binary-collations.html Quote Link to comment https://forums.phpfreaks.com/topic/155562-case-insensitive-varbinary/#findComment-818676 Share on other sites More sharing options...
jackpf Posted April 24, 2009 Author Share Posted April 24, 2009 Yeah I know...I just thought maybe mysql could perform a case insensitive search...somehow. Ahh well, thanks anyway. Quote Link to comment https://forums.phpfreaks.com/topic/155562-case-insensitive-varbinary/#findComment-818682 Share on other sites More sharing options...
fenway Posted April 27, 2009 Share Posted April 27, 2009 You can... but not on binary data, only character data. Quote Link to comment https://forums.phpfreaks.com/topic/155562-case-insensitive-varbinary/#findComment-819971 Share on other sites More sharing options...
jackpf Posted April 27, 2009 Author Share Posted April 27, 2009 Well, the entire column is a varbinary... From what i've heard it's impossible to perform a case insensitive search on varbinary. What a shame What's this character data you speak of? Quote Link to comment https://forums.phpfreaks.com/topic/155562-case-insensitive-varbinary/#findComment-820108 Share on other sites More sharing options...
Mchl Posted April 27, 2009 Share Posted April 27, 2009 It's called VARCHAR I suppose Quote Link to comment https://forums.phpfreaks.com/topic/155562-case-insensitive-varbinary/#findComment-820109 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.