pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: "König, Frank" <Frank.Koenig@rossmann.de>
To: 'pgsql-novice@postgresql.org' <pgsql-novice@postgresql.org>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
To: 'pgsql-hackers@postgresql.org' <pgsql-hackers@postgresql.org>
Subject: upper and lower doesn't work with german umlaut?
Date: Wed, 21 Nov 2001 15:15:22 +0100
Message-ID: <70F72FD9B208D511A3DB000083693A8E406918@RS-D14> (raw)

hello, what is wrong?

postgresql 7.1.3
suse linux 7.1

configure postgresql:
./configure --prefix=$DIR_DEST --exec-prefix=$DIR_DEST 
		--enable-local --enable-multibyte 
		--enable-odbc --enable-syslog --with-java

init database:
$DIR_DEST/bin/initdb --pgdata=$DIR_DB01 --encoding=LATIN1

check LANG-variable:
postgres@server:/app/pgsql/bin > echo $LANG
de_DE 

and that's the result:

	my_db=# select lower('ÄäÜüÖöß');
	  lower
	---------
	 ÄäÜüÖöß
	(1 row)               

uppercase umlauts are not converted.


thanks
frank

view thread (20+ messages)  latest in thread

Message-ID: <70F72FD9B208D511A3DB000083693A8E406918@RS-D14>
Permalink:  ../70F72FD9B208D511A3DB000083693A8E406918@RS-D14/
Also on:    postgresql.org/message-id/70F72FD9B208D511A3DB000083693A8E406918@RS-D14

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Frank.Koenig@rossmann.de, pgsql-novice@postgresql.org, pgsql-hackers@postgresql.org
  Subject: Re: upper and lower doesn't work with german umlaut?
  In-Reply-To: <70F72FD9B208D511A3DB000083693A8E406918@RS-D14>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox