From: | Vegard Munthe <vegard(at)copyleft(dot)no> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problems with lower('Å') |
Date: | 2002-12-20 12:38:42 |
Message-ID: | 20021220133814.O76859-100000@unity.copyleft.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Masaru Sugawara | 2002-12-20 14:29:00 | Re: dumping tables in non-public schemas.. |
Previous Message | Masaru Sugawara | 2002-12-20 12:25:02 | Re: [ADMIN] dumping tables in non-public schemas.. |