n" <[EMAIL PROTECTED]>; "Matt Gostick"
<[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 10:13 AM
Subject: Re: Case-Sensitive database
> On 31 Mar 2003 at 9:49, Dan Tran wrote:
>
> > I wont work for me, I dont have access to SQL layer.
>
> You can d
On 31 Mar 2003 at 9:49, Dan Tran wrote:
> I wont work for me, I dont have access to SQL layer.
You can declare your columns as VARCHAR BINARY rather than VARCHAR in
your table creation. Another possibility might be to set your
character set for the database to latin1csas rather than the defaul
I'm not sure if you can do it globally... but here is what I do:
select passwd
from blerg
where login = "Matt"
and binary login = "Matt";
I do it twice b/c the binary operation is quite slow and doing the
normal equate first speeds it up significantly.
Doesn't exactly answer your questio
: "Matt Gostick" <[EMAIL PROTECTED]>
To: "Dan Tran" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 9:41 AM
Subject: Re: Case-Sensitive database
> I'm not sure if you can do it globally... but here is wh
Hi, how do I configure mysql to be Case-Sensitive globally?
(ie where, like, clauses work with case-sensitive strings
Help is greatly appreciated.
-Dan