Re: problems when comparing text with special chars - Mailing list pgsql-novice

From Tom Lane
Subject Re: problems when comparing text with special chars
Date
Msg-id 9218.1125874177@sss.pgh.pa.us
Whole thread Raw
In response to problems when comparing text with special chars  (<me@alternize.com>)
List pgsql-novice
<me@alternize.com> writes:
> SELECT lower('zwiebelb�cker') = 'zwiebelb�cker'
> => false (which is the wrong answer, obviously)

If you think that's the wrong answer, then you need to initdb in a
locale in which it's the right answer.  Also take care that you are
using the database encoding that the locale expects.  There is some
discussion of these issues in the "localization" chapter of the
manual.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: UPDATE: pg_dump fails due to invalid memory request
Next
From:
Date:
Subject: Re: problems when comparing text with special chars