locale and german umlauts

From: Wolfgang Winkler <Wolfgang(dot)Winkler(at)digitali-concepts(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: locale and german umlauts
Date: 2001-08-01 14:21:27
Message-ID: 9k930h$6a7$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi!

I know that someone had problems before with the upper() and lower()
functions with german umlauts or polish signs. So could please anyone who
solved the problem tell me what to do to get the upper() and lower()
functions working properly?

I compiled postgres 7.1.2 with
./configure \
--with-tcl \
--with-java \
--enable-locale
make && make install
initdb -D /usr/local/pgsql/data

I set

export LC_CTYPE=de_DE.ISO8859-1
export LC_COLLATE=de_DE.ISO8859-1

and make a database with

createdb test.

Is there something obvious I'm doing wrong?

Thanks!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-08-01 14:44:19 Re: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work
Previous Message Dong, Meng 2001-08-01 10:18:15 When dealing with 'bigint'or 'int8', the command 'copy'doesn't work