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