pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)

Message-ID: <15334.1010449591@sss.pgh.pa.us>
Permalink:  ../15334.1010449591@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/15334.1010449591@sss.pgh.pa.us

 · 

reply

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