From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: unicode searches failing that use % and LIKE operators |
Date: | 2007-10-23 01:01:11 |
Message-ID: | 328.1193101271@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>> Hmph, nothing strange-looking there. I tried to reproduce the problem
>> here, without success. Now I was using 8.1.10 on Linux (I gather your
>> platform is not Linux from the spelling of the locale names)
> Really? On my Debian system the locales are named precisely like that.
> What do they look like on Red Hat?
$ locale -a | grep en_GB
en_GB
en_GB.iso88591
en_GB.iso885915
en_GB.utf8
This is on Fedora Core 6. It appears that you can *set* the locale
to "en_GB.UTF-8" successfully, but it doesn't seem to be the preferred
spelling.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2007-10-23 01:03:12 | Re: Photos from the PostgreSQL Conference Fall 2007 |
Previous Message | Raymond O'Donnell | 2007-10-23 00:19:26 | Re: Photos from the PostgreSQL Conference Fall 2007 |