| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vidyasagara Guntaka | 2004-08-23 22:11:02 | Problems with building libpq for windows |
| Previous Message | Marc G. Fournier | 2004-08-23 21:49:42 | Re: Unsupported 3rd-party solutions (Was: Few questions |