Article View: borland.public.interbase.sql
Article #11016Re: Case-insensitive collations
From: Craig Stuntz TeamB
Date: Mon, 23 Dec 2002 19:18
Date: Mon, 23 Dec 2002 19:18
22 lines
1833 bytes
1833 bytes
In article <3e0750bf$1@newsgroups.borland.com>, mikeevteev@yahoo.com says... > > How I could know which collation is case-insensetive? > Here is a lot of them... Is there some rules to know subj? > In all honesty, trial and error. If someone could create a list it would be a valuable contribution to the community. Note that some collations are case-sensitive for ORDER BY but not for WHERE (or vice-versa; I can't remember). This may or may not be a bug -- the rules for collations are complex. http://dbazine.com/gulutzen1.html -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.18712ba77013a61f98a495@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e0750bf$1@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-23 11:39:29 PST From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to email)> Newsgroups: borland.public.interbase.sql Subject: Re: Case-insensitive collations Date: Mon, 23 Dec 2002 14:18:53 -0500 Message-ID: <MPG.18712ba77013a61f98a495@newsgroups.borland.com> References: <3e0750bf$1@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 1040671126 65.86.87.242 (23 Dec 2002 11:18:46 -0800) Lines: 22 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail