Re: [HACKERS] upper and lower doesn't work with german umlaut?

Поиск
Список
Период
Сортировка
Искать

Re: [HACKERS] upper and lower doesn't work with german umlaut?

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
=?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?=  writes:
> uppercase umlauts are not converted.

Did you run initdb with the correct LANG environment?

To check, run contrib/pg_controldata and see what it says about
LC_COLLATE and LC_CTYPE.

			regards, tom lane

upper and lower doesn't work with german umlaut?

От:
"König, Frank" <Frank.Koenig@rossmann.de>
Дата:
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
FAQ