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

In response to

• Re: UTF-8 and LIKE vs = at 2004-08-23 21:46:40 from David Wheeler

pgsql-general by date

Next:	From: Vidyasagara Guntaka	Date: 2004-08-23 22:11:02
	Subject: Problems with building libpq for windows
Previous:	From: Marc G. Fournier	Date: 2004-08-23 21:49:42
	Subject: Re: Unsupported 3rd-party solutions (Was: Few questions