select lower('ÆØÅ ABC'); does not work as expected

From: willy malth <donotemailme(at)nosuchdomain(dot)xx>
To: pgsql-sql(at)postgresql(dot)org
Subject: select lower('ÆØÅ ABC'); does not work as expected
Date: 2003-05-23 14:33:45
Message-ID: 1kqza.10221$YZ6.333198@news010.worldonline.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there!

I'm useing postgresql 7.3.2, and having trouble with the lower(string)
function and the Danish special chars:

mydatabase=> select lower('ÆØÅ ABC');
lower
---------
ÆØÅ abc
(1 row)

The Danish chars does not convert to lower chars.

I've seen answers to this problem, suggesting a configure option called
--enable-locale, but this does not apply to 7.3.2 as it says in the
release notes: "Both multibyte and locale support are now always
enabled.". The --enable-locale option is no longer there.

Any ideas?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2003-05-23 15:08:16 Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST
Previous Message Bruce Young 2003-05-23 13:40:04 Re: language "plpgsql" does not exist