Re: Case-insensitive WHERE usage

Article View: borland.public.interbase.sql

Article #11013

Back to borland.public.interbase.sql Previous Next

#11013

From: Craig Stuntz TeamB
Date: Mon, 23 Dec 2002 15:48

16 lines
1721 bytes

In article <VA.00000375.02c18091@mers.com>, rschieck@mers.com says...
> 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. 
> 
	Also, RDB$RELATIONS will be small enough that the lack of an index 
for the query will not seriously hurt you.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <MPG.1870fa5f7ed41cf798a488@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!newsfeed.freenet.de!eusc.inter.net!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> <VA.00000375.02c18091@mers.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,5eb36440605f994f
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-23 08:10:11 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: Case-insensitive WHERE usage
Date: Mon, 23 Dec 2002 10:48:38 -0500
Message-ID: <MPG.1870fa5f7ed41cf798a488@newsgroups.borland.com>
References: <3e04e5fe$1@newsgroups.borland.com> <3E04EBF2.1EE39FD6@offline.no> <3e054cf3@newsgroups.borland.com> <3E05D89A.88B2E141@mindspring.com> <3e05e851$1@newsgroups.borland.com> <VA.00000375.02c18091@mers.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1040658512 65.86.87.242 (23 Dec 2002 07:48:32 -0800)
Lines: 16
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message