Received: from dep4.fciencias.unam.mx (dep4.fciencias.unam.mx [132.248.133.213]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0804ZB22101 for ; Mon, 7 Jan 2002 19:04:35 -0500 (EST) (envelope-from masm@fciencias.unam.mx) Received: (from masm@localhost) by dep4.fciencias.unam.mx (8.11.6/8.11.6) id g0806qg21293; Mon, 7 Jan 2002 18:06:52 -0600 X-Authentication-Warning: dep4.fciencias.unam.mx: masm set sender to masm@fciencias.unam.mx using -f To: "Albrecht Berger" Cc: Subject: Re: SELECT * FROM xy WHERE name LIKE '%german special char' References: <027901c197d2$562a65b0$677ba8c0@w2k> In-Reply-To: <027901c197d2$562a65b0$677ba8c0@w2k> From: Manuel Sugawara User-Name: Manuel Sugawara User-Mail-Address: masm@fciencias.unam.mx Date: 07 Jan 2002 18:06:52 -0600 Message-ID: Lines: 20 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id g080O8C23147 X-Archive-Number: 200201/46 X-Sequence-Number: 6137 "Albrecht Berger" writes: [...] > The Statement > SELECT * FROM XYZ WHERE name LIKE '%Müller%' > doesn't any of a matching row. It does work for me: regression=# select 'Müller' LIKE '%Müller%'; ?column? ---------- t (1 row) postgres version?, database encoding?, plataform? Regards, Manuel.