Re: The naive test for equality

From: Gene Wirchenko <>
Date: Thu, 11 Aug 2005 12:10:15 -0700
Message-ID: <>

On Thu, 11 Aug 2005 19:41:37 +0100, Paul <> wrote:

>David Cressey wrote:
>> The case insensitive equality test is a very good example. Better than
>> "Rationals" and better than "floating point numbers".
>> How many times have I had to write "where upcase (x.foobar) = upcase
>> (y.foobar)" in Oracle? And how many times
>> has it done a sort-merge join instead of using the index, because the index
>> was built using the case sensitive form?
>Coincidentally, I came across this thread today when looking for
>something else:
>Apparently Japanese has two ways of writing words: "katakana" and
>"hiragana" which can be treated as equal. This is supposedly similar to
>ignoring case but not exactly. To someone who doesn't read Japanese they
>would look like totally different words.
>As would some uppercase and lowercase versions of words written in the
>roman alphabet, I suppose, to someone who only knows a language with a
>different character set.

     Chinese can be written in a number of ways. I can not read Chinese script. It looks like scribble to me.


Gene Wirchenko Received on Thu Aug 11 2005 - 21:10:15 CEST

Original text of this message