From: Tom Lane <tgl@sss.pgh.pa.us>
To: Albrecht Berger <berger1517@gmx.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT * FROM xy WHERE name LIKE '%german special char'
Date: Mon, 07 Jan 2002 19:26:31 -0500
Message-ID: <15334.1010449591@sss.pgh.pa.us> (raw)
In-Reply-To: <027901c197d2$562a65b0$677ba8c0@w2k>
References: <027901c197d2$562a65b0$677ba8c0@w2k>
"Albrecht Berger" <berger1517@gmx.ch> writes:
> 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 !
The only way I could see for the underscore not to match is if the
character is actually stored as two or more bytes, but Postgres doesn't
know it should treat that sequence as a single logical character.
Are you using a multibyte character set representation (eg, Unicode)?
If so, did you build Postgres with MULTIBYTE support enabled, and did
you specify the correct character set when you created the database?
If you're not sure about this theory, try looking to see whether
length() of one of the problem strings agrees with the number of
characters you think there are.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, berger1517@gmx.ch
Subject: Re: SELECT * FROM xy WHERE name LIKE '%german special char'
In-Reply-To: <15334.1010449591@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox