🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #10955

Re: Case-insensitive collations

#10955
From: Mike Evteev
Date: Tue, 31 Dec 2002 03:49
6 lines
1303 bytes
Hi!

> 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?
Technical Details
Message-ID: <3e1113be@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <3e0750bf$1@newsgroups.borland.com> <3e079781$1@newsgroups.borland.com> <MPG.1872488d4456ab2598a4a2@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,191dc90c586a0f92
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-30 19:58:02 PST
From: "Mike Evteev" <mikeevteev@yahoo.com>
Newsgroups: borland.public.interbase.sql
References: <3e0750bf$1@newsgroups.borland.com> <3e079781$1@newsgroups.borland.com> <MPG.1872488d4456ab2598a4a2@newsgroups.borland.com>
Subject: Re: Case-insensitive collations
Date: Mon, 30 Dec 2002 19:49:24 -0800
Lines: 6
MIME-Version: 1.0
Content-Type: text/plain;
 charset="koi8-r"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 65.148.111.249
Message-ID: <3e1113be@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1041306558 65.148.111.249 (30 Dec 2002 19:49:18 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail