Skip site navigation (1) Skip section navigation (2)

Re: UTF-8 and LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Ian Barwick <barwick(at)gmail(dot)com>
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-23 22:00:42
Message-ID: E0AE38D6-F54F-11D8-990D-000A95972D84@kineticode.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group