Re: [ADMIN] Problems with select lower()

[Peter Eisentraut]

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.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] Problems with select lower()

[Tom Lane]

Andreas Schmitz <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

[ADMIN] Problems with select lower()

[Andreas Schmitz]

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

-- 



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match