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