Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From David Wheeler
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id E0AE38D6-F54F-11D8-990D-000A95972D84@kineticode.com
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: "Vidyasagara Guntaka"
Date:
Subject: Problems with building libpq for windows