Re: unicode searches failing that use % and LIKE operators

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: unicode searches failing that use % and LIKE operators
Date: 2007-10-22 23:40:11
Message-ID: 877ilehg6c.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Benjamin Weaver <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk> writes:
>> Postgres 8.1.4
>> server_encoding UTF8
>> lc_collate en_GB.UTF-8
>> lc_ctype en_GB.UTF-8
>
> 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?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-10-23 00:06:56 Re: Photos from the PostgreSQL Conference Fall 2007
Previous Message Ralph Smith 2007-10-22 22:41:36 Re: Connection & logging Problems