Problems getting german settings to work correctly

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problems getting german settings to work correctly
Date: 2002-10-02 15:24:27
Message-ID: 000001c26a27$cc10b130$5be0d089@ekelhardt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Today i tried to finally get german settings to work correctly on my
system.
I think I did everything according to the information in the docs, but
it does not work. Hopefully someone has gone thru the same procedure and
can tell me what I did wrong.

I downloaded pg722, compiled and installed

The compile options where:

configure --prefix=/usr/local/pgsql2 --enable-locale
--enable-multibyte=UNICODE

I initialized the db-cluster with initdb. The env settings at that time
where

export LANG=de_DE
export LC_ALL=de_DE

After that I started the postmaster.

I checked for the settings with pg_controldata

bash-2.05a$ ./pg_controldata
pg_control version number: 71
Catalog version number: 200201121
Database state: IN_PRODUCTION
pg_control last modified: Wed Oct 2 16:57:52 2002
Current log file id: 0
Next log file segment: 1
Latest checkpoint location: 0/1367C0
Prior checkpoint location: 0/109664
Latest checkpoint's REDO location: 0/1367C0
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 8
Latest checkpoint's NextXID: 137
Latest checkpoint's NextOID: 24748
Time of latest checkpoint: Wed Oct 2 16:57:50 2002
Database block size: 8192
Blocks per segment of large relation: 131072
LC_COLLATE: de_DE
LC_CTYPE: de_DE

Then I created a test database with 2 test tables.

Table "test1"
Column | Type | Modifiers
--------+--------------------------+-----------
int1 | integer | not null
date1 | timestamp with time zone |
Primary key: test1_pkey

I inserted a test entry in test1 and tried to query from it.

test=# select to_char(date1, 'DAY') from test1;
to_char
-----------
WEDNESDAY

I had hoped that with german settings this would be "MITTWOCH".

----------------------------------------------------------------

I created a second table to check for sorting. For this I changed the
encoding to LATIN1 and inserted several strings into the test table.

Table "test2"
Column | Type | Modifiers
----------+-----------------------+-----------
int1 | integer | not null
str_test | character varying(30) |
Primary key: test2_pkey

test=# select * from test2 order by str_test;
int1 | str_test
------+----------
10 | üüü
1 | aaa
2 | aAA
3 | AAA
14 | ööö
13 | äää
12 | ÄÄÄ
15 | ÖÖÖ
11 | ÜÜÜ
16 | ßßß
18 | bbb
17 | BBB
19 | ccc
21 | CCC
20 | DDD
9 | mmm
8 | MMM
4 | zzz
5 | zzZ
6 | zZZ
7 | ZZZ

This does not look right too.

I would be very happy about any hints to improve the situation.

Many TIA,

peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Weaver, Walt 2002-10-02 15:35:57 Re: PL/SQL Developer and TOAD
Previous Message Tommy 2002-10-02 14:38:04 .NET ODBC Driver