On 3/14/01, 6:59:18 PM, Shaw Terwilliger <[EMAIL PROTECTED]> wrote
regarding [GENERAL] Case Insensitive CHECK CONSTRAINTs:
> I have a table with a TEXT field called "username". I'd like to retain
the
> case of the data stored here, but I'd like all comparisons
Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> I have a table with a TEXT field called "username". I'd like to retain the=
> =20
> case of the data stored here, but I'd like all comparisons to be done witho=
> ut
> regard to case. Since all these accesses _should_ be done through database=
> =20
* Stephan Szabo <[EMAIL PROTECTED]> [010314 11:52] wrote:
>
> I'd guess that making the lower() index unique would possibly work.
>
> On Wed, 14 Mar 2001, Shaw Terwilliger wrote:
>
> > I have a table with a TEXT field called "username". I'd like to retain the
> > case of the data stored here,
I'd guess that making the lower() index unique would possibly work.
On Wed, 14 Mar 2001, Shaw Terwilliger wrote:
> I have a table with a TEXT field called "username". I'd like to retain the
> case of the data stored here, but I'd like all comparisons to be done without
> regard to case. Sinc
