Invalid Unicode Character Sequence found

From: "Bulatovic Natasa" <n(dot)bulatovic(at)zim(dot)mpg(dot)de>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Invalid Unicode Character Sequence found
Date: 2004-03-24 12:24:46
Message-ID: 004a01c4119b$0429fc40$e402b782@ipp.ipp.mpg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gregor Rot 2004-03-25 13:23:00 order of results
Previous Message Gregory S. Williamson 2004-03-24 00:04:16 Re: function definition documentation