RE: User-JDBC-Realm: User case-sensitiv?

2008-05-16 Thread Boyd, Todd M.
Gregor, You can use "WHERE x LIKE condition" to perform a case-sensitive search without modifying the structure of the table(s) involved by using the BINARY keyword. "SELECT * FROM `foo` WHERE `bar` LIKE BINARY 'tesT'" will not pull the record "test" or "Test", but only matches the record "tesT".

RE: User-JDBC-Realm: User case-sensitiv?

2008-05-16 Thread Boyd, Todd M.
When you think about how many people would be asking how to make them case-insensitive versus how many need to perform case-sensitive searching, it makes sense to me. Todd Boyd Web Programmer > -Original Message- > From: Gregor Schneider [mailto:[EMAIL PROTECTED] 8< snip! > I'm wonder