ilike and --enable-multibyte=KOI8 - Mailing list pgsql-general

From Juriy Goloveshkin
Subject ilike and --enable-multibyte=KOI8
Date
Msg-id 20001207175714.A17358@avias.com
Whole thread Raw
List 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
options...

--
Bye
Juriy Goloveshkin

pgsql-general by date:

Previous
From: teg@redhat.com (Trond Eivind GlomsrØd)
Date:
Subject: Re: postgresql-server-7.0.3-2.i386.rpm error
Next
From: "Brett W. McCoy"
Date:
Subject: Re: Sql query with partial matching