Re: Case-insensitive WHERE usage

Article View: borland.public.interbase.sql

Article #11010

Back to borland.public.interbase.sql Previous Next

#11010

From: Robert Schieck
Date: Mon, 23 Dec 2002 12:32

21 lines
2013 bytes

In article <3e05e851$1@newsgroups.borland.com>, Edward Diener wrote:
> I am searching the system tables for the name of a table for a given
> database. If the dialect is case-insensitive, the name passed to my function
> could refer to a name which does not exactly match the name in the
> appropriate system table. Therefore I have converted the name passed to
> uppercase and used the UPPER keyword on the appropriate column to find the
> match.
> 
> I am not sure how to use a collation driver to do the same thing.
>

You are doing just fine, you cannot use a collation driver to do the same 
thing...

Everyone assumed you were looking at your data, not system tables. 

Keep smiling

Robert Schieck (TeamB)
MER Systems Inc.
Inprise/Borland/InterBase Search Engine http://www.mers.com/searchsite.html

Technical Details

Message-ID: <VA.00000375.02c18091@mers.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!gatel-ffm!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<3e04e5fe$1@newsgroups.borland.com> <3E04EBF2.1EE39FD6@offline.no> <3e054cf3@newsgroups.borland.com> <3E05D89A.88B2E141@mindspring.com> <3e05e851$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,5eb36440605f994f
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-23 04:39:19 PST
Date: Mon, 23 Dec 2002 07:32:42 EST
Newsgroups: borland.public.interbase.sql
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Newsreader: Virtual Access by Atlantic Coast PLC, http://www.atlantic-coast.com/va
Organization: MER Systems Inc.
Message-ID: <VA.00000375.02c18091@mers.com>
Subject: Re: Case-insensitive WHERE usage
From: Robert Schieck <rschieck@mers.com>
Reply-To: rschieck@mers.com
References: <3e04e5fe$1@newsgroups.borland.com> <3E04EBF2.1EE39FD6@offline.no> <3e054cf3@newsgroups.borland.com> <3E05D89A.88B2E141@mindspring.com> <3e05e851$1@newsgroups.borland.com>
NNTP-Posting-Host: 205.207.149.16
X-Trace: newsgroups.borland.com 1040646758 205.207.149.16 (23 Dec 2002 04:32:38 -0800)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!gatel-ffm!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message