On Mon, Apr 26, 1999 at 02:15:03PM -0600, Sasha Pachev wrote:
> > Auth
> > User char(32)
> > Pwd char(16)
> >
> > Select * from Auth where User='barry' and strcmp(Pwd,'Sch')=0
> >
> > It does what I want. Is this the best way?
No, it's likely to be quite a bit slower than the other solutions.
> 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.
s/insensitive\./sensitive./
Instead of declaring it as a BLOB, just use the BINARY keyword
when you define the field. Look at the CREATE TABLE docs for
more info on the BINARY attribute. Obviously, you'll want Pwd to
be BINARY and User to be normal.
Tim

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.