Problems with lower('Å') - Mailing list pgsql-general

From Vegard Munthe
Subject Problems with lower('Å')
Date
Msg-id 20021220133814.O76859-100000@unity.copyleft.no
Whole thread Raw
Responses Re: Problems with lower('Å')  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
'SELECT lower('Å')' returns Å. I have tried server_encoding and
client_encoding LATIN1 and ASCII.

I do not have the same problem on my GNU/linux server with the same
pgsql setup.

Does anyone have a clue to how I can fix this problem?

Server:
-------
FreeBSD 4.4-RELEASE

PostGreSQL:
-----------
7.1.3
7.2.3

Pgsql env:
----------
USER=pgsql
MAIL=/var/mail/pgsql
HOME=/var/db/pgsql
PGLIB=/usr/local/lib
PGDATESTYLE=ISO
TERM=vt320
BLOCKSIZE=K

PATH=/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/var/db/pgsql/bin
SHELL=/bin/sh
LC_ALL=no_NO.ISO_8859-1
PGDATA=/var/db/pgsql/data

/usr/share/locale has amung other dirs:
---------------------------------------
no_NO.ISO_8859-1/
la_LN.ISO_8859-1/


-- Vegard Munthe



pgsql-general by date:

Previous
From: "Madhavi"
Date:
Subject: drop foreign key
Next
From: Tom Lane
Date:
Subject: Re: Unable to format timestamp with time zone; internal coding error