Is it a bug ?

From: "Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Is it a bug ?
Date: 2006-04-25 09:02:16
Message-ID: 200604250905.k3P950IQ010685@Citrus.usj.edu.lb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I just noticed a bug in PostgreSQL 7.3.2

I don't know if it exists in other versions

If I have a UNICODE database and I make the following query

SELECT * FROM table where code like 'abcz%';

Or

SELECT * FROM table where code like 'abcz_';

(or anything that ends with z% or z_)

It gives the following error :

ERROR: Invalid UNICODE character sequence found (0xc000)

Other queries like

SELECT * FROM table where code ilike 'abcz%';

SELECT * FROM table where code like '%abcz%';

Or the same query but in an SQL_ASCII database don't give the same error

Is it a bug in Postgres ????

I'd appreciate an explanation

Thx

Pascal

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-04-25 09:34:32 Re: Is it a bug ?
Previous Message Bruno Cortes 2006-04-25 09:00:08 Re: FATAL: catalog is missing attributes