On Mon, 26 Nov 2001, Marjolein Katsma wrote:
> Paul,
>
> At 16:56 2001-11-25 -0600, Paul DuBois wrote:
> >database,sql,query,table
> >
> >At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote:
> >>At 12:19 2001-11-25 -0600, Paul DuBois wrote:
> select * from users where dbname= "Brain" returns
Paul,
At 16:56 2001-11-25 -0600, Paul DuBois wrote:
>database,sql,query,table
>
>At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote:
>>At 12:19 2001-11-25 -0600, Paul DuBois wrote:
select * from users where dbname= "Brain" returns both "brain" and "Brain".
I read section 6.3.2.2 and s
database,sql,query,table
At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote:
>At 12:19 2001-11-25 -0600, Paul DuBois wrote:
>>>select * from users where dbname= "Brain" returns both "brain" and "Brain".
>>>
>>>I read section 6.3.2.2 and select binary dbname from users where
>>>dbname="brain" also
At 12:19 2001-11-25 -0600, Paul DuBois wrote:
select * from users where dbname= "Brain" returns both "brain" and "Brain".
I read section 6.3.2.2 and select binary dbname from users where
dbname="brain" also returns both records.
SELECT dbname FROM users WHERE BINARY dbname = "brain"
perhaps?
At 11:23 PM -0500 11/24/01, Gary Huntress wrote:
>I have a table of user info containing mixed case text. One user has
>created a database named "brain" and another has created a database "Brain".
>I was surprised to see that:
>
>select * from users where dbname= "Brain" returns both "brain" and