Invalid UNICODE character sequence found(0xc000)

[Antonio Gallardo]

psql returns:

Invalid UNICODE character sequence found(0xc000) in a valid query.

Steps to reproduce:

1. createdb -E UNICODE mydbname.
2. create a table with some varchar inside, we will query on this field.
Example:

CREATE TABLE auth_role
(
rol_id int4 not null default
nextval('auth_rol_rol_id_seq'),
rol_name varchar(50) unique not null,
rol_enable boolean default true,

primary key(rol_id)
);

INSERT INTO auth_role(rol_name,rol_enable) VALUES ('admin',true);
INSERT INTO auth_role(rol_name,rol_enable) VALUES ('zorro',true);

3. run psql and write a select like this:

SELECT * FROM AUTH_ROLE WHERE ROL_NAME LIKE 'z%';

4. I got the error.

Comments:

If in the LIKE we don't use the 'z%' this query runs OK. Examples:

LIKE 'zo%' ---- OK returns 1 row.
LIKE 'r%' ---- OK returns 0 rows.
LIKE 'az%' ---- ERROR again (contains z%).

Version:
the "SELECT version();" returns:
PostgreSQL 7.3.4-RH on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)

OS: Fedora Core 1
Please help. I think this is a bug, but I am not sure.

Best Regards,

Antonio Gallardo



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings