| From: | "König, Frank" <Frank(dot)Koenig(at)rossmann(dot)de> | 
|---|---|
| To: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | upper and lower doesn't work with german umlaut? | 
| Date: | 2001-11-21 14:15:22 | 
| Message-ID: | 70F72FD9B208D511A3DB000083693A8E406918@RS-D14 | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers pgsql-novice | 
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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Björn Lundin | 2001-11-21 16:31:32 | Re: Problems between Mandrake and pg | 
| Previous Message | Ryan Rohde Hansen | 2001-11-21 13:44:04 | Problems between Mandrake and pg | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-11-21 14:39:23 | Re: SPI and CommandCounterIncrement, redux | 
| Previous Message | Thomas Lockhart | 2001-11-21 14:11:14 | Regression tests need updating... | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ezra Epstein | 2001-11-21 15:30:50 | Oracle -> PostgreSQL ==> RAW -> ??? | 
| Previous Message | Andrew Bell | 2001-11-21 14:02:27 | Update from a table. |