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