X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C64ACD1DC7D for ; Wed, 24 Mar 2004 12:25:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57365-08 for ; Wed, 24 Mar 2004 08:25:05 -0400 (AST) Received: from post.rzg.mpg.de (post.rzg.mpg.de [130.183.9.21]) by svr1.postgresql.org (Postfix) with ESMTP id 0FC66D1ECD3 for ; Wed, 24 Mar 2004 08:25:01 -0400 (AST) Received: from zim03 (zim03.ipp.mpg.de [130.183.2.228]) by post.rzg.mpg.de (8.9.2/8.9.2) with ESMTP id NAA49398 for ; Wed, 24 Mar 2004 13:24:52 +0100 X-Envelope-To: From: "Bulatovic Natasa" To: Subject: Invalid Unicode Character Sequence found Date: Wed, 24 Mar 2004 13:24:46 +0100 Message-ID: <004a01c4119b$0429fc40$e402b782@ipp.ipp.mpg.de> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/252 X-Sequence-Number: 17351 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