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 ?
---
[EMAIL PROTECTED]
http://www.net-connection.de
http://www.tradenet32.de
************
