Subject RE: [IBO] Case insensitive index
Author Bob Jones

Thanks. That's how it works for Oracle, too. However, I don't follow the
need for the NOCASE ColumnAttribute. Won't I be searching on the uppercase
index? Forgive my ignorance here.

Sounds like I'm going to have to purchase the documentation after all, huh?


-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, October 17, 2001 6:32 PM
Subject: Re: [IBO] Case insensitive index

No, you have to maintain an uppercase equivalent column and put an index on
Then, there is a NOCASE ColumnAttribute setting which will tell IBO to
substitute appropriately to accomplish case insensitive searching, etc.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Bob Jones" <bjones@...>
To: "IBObjects@yahoogroups. com" <>
Sent: Wednesday, October 17, 2001 3:06 PM
Subject: [IBO] Case insensitive index

> How do I create an index that is not case sensitive? Is there a property
> that I set to ignore case on the index, or does Interbase support
> indexes?
> Thanks.
> Bob

Your use of Yahoo! Groups is subject to