Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * FROM xy WHERE name LIKE '%german special char' - Mailing list pgsql-sql

From Manuel Sugawara
Subject Re: SELECT * FROM xy WHERE name LIKE '%german special char'
Date
Msg-id m3r8p1wvs3.fsf@dep4.fciencias.unam.mx
Whole thread Raw
In response to SELECT * FROM xy WHERE name LIKE '%german special char'  ("Albrecht Berger" <berger1517@gmx.ch>)
List pgsql-sql
Tree view 
"Albrecht Berger" <berger1517@gmx.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.

pgsql-sql by date:

Previous
From: "Albrecht Berger"
Date:
Subject: SELECT * FROM xy WHERE name LIKE '%german special char'
Next
From: Tom Lane
Date:
Subject: Re: SELECT * FROM xy WHERE name LIKE '%german special char'