Re: UTF-8 and LIKE vs =

On Aug 30, 2004, at 5:34 PM, Michael Glaesemann wrote:

> Just a wee thing, and perhaps not the point of the post, but collation
> is not important only for indexes. (Actually, I wouldn't be surprised
> if some indexes are not necessarily ordered, but that may be my
> inexperience talking.) You don't need an index on column foo to be
> able to ORDER BY foo.

Yes, I know that. I guess I should've left mention of indexes out of
it. I was still thinking in terms of my original issue, where a query
for a particular string found no results when it should have because
the index was using the en_us.utf8 locale.

Regards,

David