Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 40BDD2E3FFC for ; Tue, 5 Feb 2008 11:57:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 84589-01-10 for ; Tue, 5 Feb 2008 11:57:26 -0400 (AST) Received: from webmail.hansenet.de (mx02.hansenet.de [213.191.73.26]) by postgresql.org (Postfix) with ESMTP id 032B72E3C16 for ; Tue, 5 Feb 2008 11:54:27 -0400 (AST) Received: from [62.109.88.130] (62.109.88.130) by webmail.hansenet.de (7.3.118.12) id 479FE9B3012E1DE1 for pgsql-admin@postgresql.org; Tue, 5 Feb 2008 16:54:25 +0100 From: jkohlmeier@pronet-systeme.de Subject: PG 8.2 change Letter Sort Order To: pgsql-admin@postgresql.org Date: Tue, 5 Feb 2008 15:54:25 +0000 X-Priority: 3 (Normal) Importance: normal X-Mailer: DvISE by Tobit Software, Germany (0233.4442454A4B464C4B514F), Mime Converter 101.20 X-David-Sym: 0 X-David-Flags: 33554432 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_000_000075D3.47A894C1" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/28 X-Sequence-Number: 28102 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_000075D3.47A894C1 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello Group, I have a Database for German Text using UTF-8 and want to change the sort = order of Letters. Creation Database: initdb -E UTF-8 --locale=3Dde_DE.UTF-8 --lc-collate=3Dde_DE.UTF-8 = --lc-ctype=3Dde_DE.UTF-8 -D DBPath The Sort set with --lc-collate=3Dde_DE.UTF-8 was not the right Sort Order = ( =DF=3D>=E4=3D>aa=3D>=E4b). I need a sort where =DF=3D=3Dss and =E4 = =3D=3Dae. Is there an over Value for lc_collate who changes the Sort Order? = (de_DE.ISO8859-1,C,POSIX dosent change it correctly Or can i change the Sort Orders in Postgresqls Config Files? I havent = found the correct ones OS: Solaris 10=20 PG 8.2 Thanks for Help Jens ------_=_NextPart_000_000075D3.47A894C1 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello Group,
 
I have a Database for German Text using UTF-8 and want to change the = sort=20 order of Letters.
 
Creation Database:
initdb  -E UTF-8 --locale=3Dde_DE.UTF-8 = --lc-collate=3Dde_DE.UTF-8=20 --lc-ctype=3Dde_DE.UTF-8 -D DBPath
 
The Sort set with --lc-collate=3Dde_DE.UTF-8 was not the right Sort = Order (=20 =DF=3D>=E4=3D>aa=3D>=E4b). I need a sort where =DF=3D=3Dss and = =E4 =3D=3Dae.
Is there an over Value for lc_collate who changes the Sort Order?=20 (de_DE.ISO8859-1,C,POSIX dosent change it correctly
Or can i change the Sort Orders in Postgresqls Config Files? I = havent=20 found the correct ones
 
OS:
Solaris 10
PG 8.2
 
Thanks for Help
 
Jens
------_=_NextPart_000_000075D3.47A894C1--