Re: SELECT * FROM xy WHERE name LIKE '%german special char'

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: "Albrecht Berger" <berger1517(at)gmx(dot)ch>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SELECT * FROM xy WHERE name LIKE '%german special char'
Date: 2002-01-08 00:06:52
Message-ID: m3r8p1wvs3.fsf@dep4.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Albrecht Berger" <berger1517(at)gmx(dot)ch> 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Luis Miguel Castañeda 2002-01-08 00:21:58 Re: problems with single quotes..
Previous Message Tom Lane 2002-01-07 23:25:41 Re: simple? join