| Subject | Re: about nocase collation | 
|---|---|
| Author | donoteatcarrot | 
| Post date | 2005-09-05T12:47:28Z | 
Hello, Ivan.
Thank you very much for your reply.
What dose "Unless you need to use index" means ?
I created a index for that column, but the result is the same.
Ryu
<Ivan.Prenosil@s...> wrote:
            Thank you very much for your reply.
What dose "Unless you need to use index" means ?
I created a index for that column, but the result is the same.
Ryu
<Ivan.Prenosil@s...> wrote:
> LIKE (and STARTING) ignores collation.
> Unless you need to use index, try
> upper(f1) LIKE upper(f2)
>
>
> Ivan