> Hello All,
> I am a semi-newbie so this should be a super easy one. I am doing a simple
> authorization db for our web server. As a test I created the following db.
> User char(32)
> Pwd char(16)
> and entered the following
> User Pwd
> Barry Sch
> if I do the any of the following in the utility myAdmin
> Select * from Auth where User='Barry' and Pwd='Sch'
> Select * from Auth where User='barry' and Pwd='scH'
> Select * from Auth where User='BARRY' and Pwd='sCh'
> it returns the Barry Sch row shown above.
> I would like to do a Select where User is not case sensitive, but where Pwd
> is case sensitive. Searching the manual I came up with:
> Select * from Auth where User='barry' and strcmp(Pwd,'Sch')=0
> It does what I want. Is this the best way?
There is an alternative way, I do not now if it is any
better. Make your data type blob instead of char, and
then = operator will be case-insensitive.