Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group