Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Schmitz
Subject Problems with select lower()
Date
Msg-id 200404221055.17022.a.schmitz@cityweb.de
Whole thread Raw
Responses Re: Problems with select lower()  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Problems with select lower()  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Tree view 
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

--

pgsql-admin by date:

Previous
From: Fischer Ulrich
Date:
Subject: Restoring a Databases that features tserach2
Next
From: Fischer Ulrich
Date:
Subject: Re: Restoring a Databases that features tserach2