Subject Re: [ib-support] Re: Firebird support case insensitive??
Author Ann W. Harrison
At 11:56 PM 12/26/2001 +0000, jwcanada wrote:

>> One is a set of special operators that are explicitly
> > case insensitive. That's really non-standard, but it's
> > very clean, architecturally.
>This is ideal as MS SQL Server has such settings. Its default is

I think you misunderstood me. What I meant was that we would
have special operators (e.g. ~= meaning equal ignoring case, or
~> meaning greater than ignoring case). Frankly, I find setting
the whole database to case insensitive or sensitive to be a bad
idea ... sooner or later you're going to need to compare data
between databases... and some character data is inherently case
sensitive (e.g. passwords).


We have answers.