Invalid UNICODE character sequence found(0xc000)

From: "Antonio Gallardo" <antonio(at)apache(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Invalid UNICODE character sequence found(0xc000)
Date: 2004-01-09 15:02:42
Message-ID: 35399.10.0.0.5.1073660562.squirrel@ags01.agsoftware.dnsalias.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-09 15:25:49 Re: array faults?
Previous Message jeffrey rivero 2004-01-09 14:51:53 Re: Natural upgrade path for RedHat 9?