Обсуждение: Invalid Unicode Character Sequence found

Hi All,

One very strange problem within the PostgreSql database.

When you issue the following command:

select id, title from docs where title like 'z%'; or 
select id, title from docs where title like 'Z%';

It reports the following error:
ERROR:  Invalid UNICODE character sequence found (0xc000)

I tried the same query on different tables in different databases -
gives the same error message.
The same error message appears to be even when the table is completely
empty!

Any ideas?
We run postgres 7.3.2 and default charset is UNICODE.


Cheers
Natasa

"Bulatovic Natasa" <n.bulatovic@zim.mpg.de> writes:
> select id, title from docs where title like 'z%'; or 
> select id, title from docs where title like 'Z%';
> It reports the following error:
> ERROR:  Invalid UNICODE character sequence found (0xc000)

This is fixed in 7.3.6.
        regards, tom lane

В Птн, 26.03.2004, в 22:43, Tom Lane пишет:
> "Bulatovic Natasa" <n.bulatovic@zim.mpg.de> writes:
> > select id, title from docs where title like 'z%'; or
> > select id, title from docs where title like 'Z%';
> > It reports the following error:
> > ERROR:  Invalid UNICODE character sequence found (0xc000)
>
> This is fixed in 7.3.6.

I remember to have stumbled over this bug, too. I poked around in the
code a bit but found nothing that hinted to cause of the bug. So I
wonder what the cause of this bug was?

--
Markus Bertheau <twanger@bluetwanger.de>

Yes, indeed very strange.
However, it is certainly fixed, because I also tried more advanced
version of postgres and this bug was not in there.

Regards
Natasa

> -----Original Message-----
> From: Markus Bertheau [mailto:twanger@bluetwanger.de]
> Sent: Saturday, March 27, 2004 11:02 AM
> To: Tom Lane
> Cc: Bulatovic Natasa; pgsql-sql@postgresql.org
> Subject: Re: [SQL] Invalid Unicode Character Sequence found
>
>
> В Птн, 26.03.2004, в 22:43, Tom Lane пишет:
> > "Bulatovic Natasa" <n.bulatovic@zim.mpg.de> writes:
> > > select id, title from docs where title like 'z%'; or
> > > select id, title from docs where title like 'Z%';
> > > It reports the following error:
> > > ERROR:  Invalid UNICODE character sequence found (0xc000)
> >
> > This is fixed in 7.3.6.
>
> I remember to have stumbled over this bug, too. I poked
> around in the code a bit but found nothing that hinted to
> cause of the bug. So I wonder what the cause of this bug was?
>
> --
> Markus Bertheau <twanger@bluetwanger.de>
>
>