Is it a bug ?

["Pascal Tufenkji" <ptufenkji@xxxxxxxxxx>]

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