Обсуждение: upper and german umlauts
Hi, i installed pgsql 7.0beta1 and i'm having problems with some special german characters. LC_COLLATE and LC_CTYPE is set to de_DE, i also tried LC_CTYPE=iso_8859_1 and de_DE.88591 Then i created a test-table with one varchar and one text field and inserted records with the values a,b,d,ä,ö and ü. Select upper (varcharfield), upper (textfield) will give me uppercase a,b,c but the ä,ö and ü will not be changed. In case you cant see ä,ö and ü, it is a,o and u with two dots on. In /usr/share/locale/de_DE i have the following files: -rw-r--r-- 1 root root 29970 Sep 9 20:49 LC_COLLATE -rw-r--r-- 1 root root 10428 Sep 9 20:49 LC_CTYPE drwxr-xr-x 2 root root 1024 Feb 22 20:28 LC_MESSAGES -rw-r--r-- 1 root root 94 Sep 9 20:49 LC_MONETARY -rw-r--r-- 1 root root 27 Sep 9 20:49 LC_NUMERIC -rw-r--r-- 1 root root 492 Sep 9 20:49 LC_TIME Pgsql is configured with the following flags: --prefix=/usr \ --enable-hba --enable-locale \ --with-perl \ --with-tcl --with-tk --with-x \ --with-odbc --with-java \ --with-python I'm using Mandrake-Linux with glibc-2.1.1. Can someone tell me what's wrong ? --- diehl@net-connection.de http://www.net-connection.de http://www.tradenet32.de
On Tue, 7 Mar 2000, Armin Diehl wrote: > In /usr/share/locale/de_DE i have the following files: > -rw-r--r-- 1 root root 29970 Sep 9 20:49 LC_COLLATE > -rw-r--r-- 1 root root 10428 Sep 9 20:49 LC_CTYPE > drwxr-xr-x 2 root root 1024 Feb 22 20:28 LC_MESSAGES > -rw-r--r-- 1 root root 94 Sep 9 20:49 LC_MONETARY > -rw-r--r-- 1 root root 27 Sep 9 20:49 LC_NUMERIC > -rw-r--r-- 1 root root 492 Sep 9 20:49 LC_TIME Are you sure it is correct data? Test it. Look into Postgres' src/test/locale and create a test for your locale similar to those that are there. I want to see your test - I am collecting such test for different locales. Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they just GOSUB without RETURN.
> Are you sure it is correct data? Test it. Look into Postgres' > src/test/locale and create a test for your locale similar to those that are > there. I want to see your test - I am collecting such test for different > locales. > Ok, i will do my best :-) --- diehl@net-connection.de http://www.net-connection.de http://www.tradenet32.de
Hi Oleg, i have done some tests. I checked src/test/locale/koi8-r and that works. src/test/locale/ISO8859-7 and also my de_DE.8859.1 did not work. The reason: i tryed it with de_DE.ISO8859-1 but on my system in /usr/share/locale/i18n/charmaps/ i found only a file named ISO-8859-1 so i tryed that and, it works fine. Attached you will find a test for de_DE.ISO-8859-1. Thanks for help. Armin > > Are you sure it is correct data? Test it. Look into Postgres' > src/test/locale and create a test for your locale similar to those that are > there. I want to see your test - I am collecting such test for different > locales. > > Oleg.