Article View: borland.public.interbase.sql
Article #11022Re: Case-insensitive collations
From: Craig Stuntz TeamB
Date: Tue, 24 Dec 2002 15:34
Date: Tue, 24 Dec 2002 15:34
16 lines
1839 bytes
1839 bytes
In article <3e079781$1@newsgroups.borland.com>, info@clevercomponents.com says... > To be more specific collations like EN_US, DU_NL, FR_FR etc. seems to be > case insensitive so probably you can rely on naming convention but if you > can run some tests then it will be more obvious. > Note that a collation which is case-insensitive for an ORDER BY is not necessarily case-insensitive for a WHERE clause, and vice versa. -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.1872488d4456ab2598a4a2@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!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e0750bf$1@newsgroups.borland.com> <3e079781$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-24 07:39:33 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, 24 Dec 2002 10:34:23 -0500 Message-ID: <MPG.1872488d4456ab2598a4a2@newsgroups.borland.com> References: <3e0750bf$1@newsgroups.borland.com> <3e079781$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 1040744066 65.86.87.242 (24 Dec 2002 07:34:26 -0800) Lines: 16 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!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail