Hi Todd,
On Fri, May 16, 2008 at 11:23 PM, Boyd, Todd M. <[EMAIL PROTECTED]> wrote:
>
> 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.
>
well, I could so so - however, I'm talking ab
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".
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gregor,
Gregor Schneider wrote:
| thanks a lot, that's the reason why.
|
| I'm wondering what those guys from MySQL thought when introducing this
| "feature"...
Try this:
ALTER TABLE users
~ MODIFY COLUMN user_name VARCHAR(40) BINARY
;
No need t
Todd,
I absolutly disagree:
A database is a container holding some peaces of information.
Usually, a database is transparent for the programmer: He doesn't need
to about the details of the soring-mechanisms, but *what* he has to
know is that "fooBar" != "FooBar" - fullstop.
if you application n
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
Hi Paul.
thanks a lot, that's the reason why.
I'm wondering what those guys from MySQL thought when introducing this
"feature"...
Anyways, thanks again!
Gregor
--
what's puzzlin' you, is the nature of my game
gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2
gpgp-key available @ http://pgpkeys
Gregor Schneider wrote:
Hi guys,
I'm just a bit puzzled, maybe one of you can shed some light:
We're running Tomcat 5.5 here having created a JDBC-realm holding our
users & their credentials:
The DDL of the MySQL-Tables shows like
However, we've just discovered that Tomcat doesn't care at all