Subject Re: about nocase collation
Author donoteatcarrot
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:
> LIKE (and STARTING) ignores collation.
> Unless you need to use index, try
> upper(f1) LIKE upper(f2)
>
>
> Ivan