ilike and --enable-multibyte=KOI8

From: Juriy Goloveshkin <juriy(at)avias(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ilike and --enable-multibyte=KOI8
Date: 2000-12-08 07:38:33
Message-ID: 20001208103833.A6003@avias.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, Can anybody check and confirm(or not) this:

if pgsql(DEVEL, from cvs-server) is built with locale and multibyte then

"select * from table where row ilike '%a%'" crashes pgsql.
"select * from table where row ilike 'a%'" doesn't craches.
"select * from table where row like '%a%'" doesn't craches.

If pgsql is built only with locale, pgsql isn't crashed...

please, give me an advice for solving this problemm. I need pgsql with both
this options...

--
Bye
Juriy Goloveshkin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2000-12-08 09:26:32 Re: UNION within VIEW workarounds?
Previous Message Andrew Nosenko 2000-12-08 07:33:46 Re: Oracle-compatible lpad/rpad behavior