Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: The naive test for equality

Re: The naive test for equality

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Thu, 11 Aug 2005 12:10:15 -0700
Message-ID: <ni8nf1pabpp39e6oetnums05qo0crpnerq@4ax.com>


On Thu, 11 Aug 2005 19:41:37 +0100, Paul <paul_at_test.com> 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:
>http://groups.google.co.uk/group/comp.databases.postgresql.general/browse_frm/thread/24b0fdd2e35914ed/1d93176ebc116af3?lnk=st&q=korean+postgresql+sort+order&rnum=6&hl=en#1d93176ebc116af3
>
>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.

Sincerely,

Gene Wirchenko Received on Thu Aug 11 2005 - 14:10:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US