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

From: "Albrecht Berger" <berger1517(at)gmx(dot)ch>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: SELECT * FROM xy WHERE name LIKE '%german special char'
Date: 2002-01-07 23:23:37
Message-ID: 027901c197d2$562a65b0$677ba8c0@w2k
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-01-07 23:25:41 Re: simple? join
Previous Message Peter Eisentraut 2002-01-07 22:52:53 Re: simple? join