Re: problems when comparing text with special chars

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: me(at)alternize(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problems when comparing text with special chars
Date: 2005-09-04 22:49:37
Message-ID: 9218.1125874177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<me(at)alternize(dot)com> writes:
> SELECT lower('zwiebelbcker') = 'zwiebelbcker'
> => 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message me 2005-09-04 23:11:50 Re: problems when comparing text with special chars
Previous Message Tom Lane 2005-09-04 22:45:57 Re: UPDATE: pg_dump fails due to invalid memory request