Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (8.11.3/8.11.4) with SMTP id g07NQ5B14609 for ; Mon, 7 Jan 2002 18:26:05 -0500 (EST) (envelope-from berger1517@gmx.ch) Received: (qmail 22358 invoked by uid 0); 7 Jan 2002 23:26:06 -0000 Received: from pd9001c0d.dip.t-dialin.net (HELO w2k) (217.0.28.13) by mail.gmx.net (mp014-rz3) with SMTP; 7 Jan 2002 23:26:06 -0000 Message-ID: <027901c197d2$562a65b0$677ba8c0@w2k> From: "Albrecht Berger" To: Subject: SELECT * FROM xy WHERE name LIKE '%german special char' Date: Tue, 8 Jan 2002 00:23:37 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200201/45 X-Sequence-Number: 6136 Hello, in my postgres db i have several Tables with german Special Chars like ÄÖÜßäöü. I have no problem displaying them with any terminal, php, jdbc and so on, but the like pattern doesn't find any of this special chars. The Statement SELECT * FROM XYZ WHERE name LIKE '%Müller%' doesn't any of a matching row. Is there a solution for this problem ? LIKE '%M_ller%' doesn't work, too ! I don't want to change the data in the tables, because displaying the data is ok, but i have to search in it. Thanks Berger