From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Antonio Gallardo <antonio(at)apache(dot)org> |
Cc: | Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: [BUG] - Invalid UNICODE character sequence found(0xc000) |
Date: | 2004-01-09 14:33:33 |
Message-ID: | 1073658813.15079.70.camel@coppola.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
As I previously suggested, post it to the general list.
And add (again) the info about:
- software you use;
- OS, terminal encoding: might be relevant.
Cheers,
Csaba.
On Fri, 2004-01-09 at 15:18, Antonio Gallardo wrote:
> OK. Confirmed:
>
> 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%';
>
> After all you was right, this is not a JDBC related bug! :-D
>
> Since we can also reproduce it using psql. I hoped it was my fault, but
> looks like a postgresql bug. :-(
>
> Please confirm the bug.
>
> Best Regards,
>
> Antonio Gallardo
>
> > in psql 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)
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2004-01-09 14:37:27 | Re: PreparedStatement parameters and mutable objects |
Previous Message | Csaba Nagy | 2004-01-09 14:31:03 | Re: [BUG] - Invalid UNICODE character sequence found(0xc000) |