Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group