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