Re: UTF-8 and LIKE vs =

On Aug 23, 2004, at 2:46 PM, David Wheeler wrote:

> I think that LIKE is doing the right thing, and = is not. And I need
> to find out how to get = to do the right thing. If I need to dump my
> database and run initdb to use C for LC_COLLATE, the, feh, I will.
> Right now I have:
>
> LC_COLLATE:                           en_US.UTF-8
> LC_CTYPE:                             en_US.UTF-8

And testing on another box with these set to "C", it seems to work
properly.

*sigh* Nothing like dumping and restoring a 2.7 GB database to keep me
engaged in what I'm doing, eh?

Regards,

David