Re: Case-insensitive collations

Article View: borland.public.interbase.sql

Article #10958

Back to borland.public.interbase.sql Previous Next

#10958

From: Craig Stuntz TeamB
Date: Tue, 31 Dec 2002 15:28

19 lines
1882 bytes

In article <3e1113be@newsgroups.borland.com>, mikeevteev@yahoo.com says...
> > Note that a collation which is case-insensitive for an ORDER BY is 
> > not necessarily case-insensitive for a WHERE clause, and vice versa.
> 
> How so?
> 
	Some collations are case-sensitive for WHERE, but case-insensitive 
for ORDER BY, IIRC (or is it the opposite?).  This isn't documented -- you 
have to test the collations to find one which works for you.  The 
important thing to know is that you shoult test both WHERE and ORDER BY 
when evaluating collations.

	-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.187b8192a10a62698a4c7@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed.esat.net!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<3e0750bf$1@newsgroups.borland.com> <3e079781$1@newsgroups.borland.com> <MPG.1872488d4456ab2598a4a2@newsgroups.borland.com> <3e1113be@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,191dc90c586a0f92
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-31 07:40:06 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: Case-insensitive collations
Date: Tue, 31 Dec 2002 10:28:04 -0500
Message-ID: <MPG.187b8192a10a62698a4c7@newsgroups.borland.com>
References: <3e0750bf$1@newsgroups.borland.com> <3e079781$1@newsgroups.borland.com> <MPG.1872488d4456ab2598a4a2@newsgroups.borland.com> <3e1113be@newsgroups.borland.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1041348482 65.86.87.242 (31 Dec 2002 07:28:02 -0800)
Lines: 19
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed.esat.net!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message