Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with select lower() - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problems with select lower()
Date
Msg-id 25228.1082638348@sss.pgh.pa.us
Whole thread Raw
In response to Problems with select lower()  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-admin
Tree view 
Andreas Schmitz <a.schmitz@cityweb.de> writes:
> I have a problem with select lower() using capital letters with diaeresis. I
> tried with encoding SQL_ASCII und UNICODE.

upper/lower currently only work with single-byte characters, so you need
to use one of the LATINn database encodings rather than UNICODE if you
want this functionality.

            regards, tom lane

pgsql-admin by date:

Previous
From: Fischer Ulrich
Date:
Subject: Re: Restoring a Databases that features tserach2
Next
From: Peter Eisentraut
Date:
Subject: Re: Problems with select lower()