Обсуждение: Problems with select lower()

Hello *,

I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.


newsdb=# select lower('Ökosteuer');
   lower
------------
 Ökosteuer
(1 row)

newsdb=# select lower('Andreas');
  lower
---------
 andreas
(1 row)

Any Ideas ?

regards,

-Andreas

--

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

Am Donnerstag, 22. April 2004 10:55 schrieb Andreas Schmitz:
> I have a problem with select lower() using capital letters with diaeresis.
> I tried with encoding SQL_ASCII und UNICODE.

You need to set your locale to something useful (de_DE), not the encoding.
And lower() doesn't work with Unicode, but that is an independent issue.