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
