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
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 |