Skip site navigation (1) Skip section navigation (2)

upper and german umlauts

From: "Armin Diehl" <diehl(at)net-connection(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: upper and german umlauts
Date: 2000-03-07 14:03:41
Message-ID: 200003071303.IAA31026@hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)net-connection(dot)de
http://www.net-connection.de
http://www.tradenet32.de


Responses

pgsql-admin by date

Next:From: Armin DiehlDate: 2000-03-07 14:32:16
Subject: Re: [ADMIN] upper and german umlauts
Previous:From: terpanDate: 2000-03-07 13:52:40
Subject: Re: [ADMIN] Is it possible...?...sanx!...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group