Problems with select lower()

From: Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problems with select lower()
Date: 2004-04-22 08:55:17
Message-ID: 200404221055.17022.a.schmitz@cityweb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

--

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fischer Ulrich 2004-04-22 11:00:11 Re: Restoring a Databases that features tserach2
Previous Message Fischer Ulrich 2004-04-22 08:55:06 Restoring a Databases that features tserach2