Thread: AW: case insensitive database ?

AW: case insensitive database ?

From
Thorsten Mauch
Date:
Thanks for the answers.
My prob is that i don't query the database
directly. I use the CASTOR as a persitence-Framework.
I create QOL-queries that are translated into
SQL-Queries by the framework.
So i can't use ILIKE or UPPER(expr) :(
I also can't force the use of a special index.
Howerver, i have to maintain a second field with upper
letters, that i query instead of the orginal field

Thorsten

Re: AW: case insensitive database ?

From
Joel Burton
Date:
On Wed, 25 Apr 2001, Thorsten Mauch wrote:

> Thanks for the answers.
> My prob is that i don't query the database
> directly. I use the CASTOR as a persitence-Framework.
> I create QOL-queries that are translated into
> SQL-Queries by the framework.
> So i can't use ILIKE or UPPER(expr) :(
> I also can't force the use of a special index.
> Howerver, i have to maintain a second field with upper
> letters, that i query instead of the orginal field

could you create a view and query that?

CREATE TABLE pers (fname);

INSERT INTO pers VALUES ('Joel');

CREATE VIEW pers_use_me AS SELECT fname, lower(fname) as lower_fname
FROM pers;

SELECT * FROM pers WHERE lower_fname = 'joel';


HTH,
--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington