From jkohlmeier@pronet-systeme.de Tue Feb 5 15:57:51 2008 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-- From michael.monnerie@it-management.at Tue Feb 5 21:22:46 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3BC782E4054 for ; Tue, 5 Feb 2008 17:22:46 -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 19645-03 for ; Tue, 5 Feb 2008 17:22:37 -0400 (AST) Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by postgresql.org (Postfix) with ESMTP id 03B852E4051 for ; Tue, 5 Feb 2008 17:22:41 -0400 (AST) Received: from mailsrv.i.zmi.at (85-125-129-125.neutorgasse.xdsl-line.inode.at [85.125.129.125]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "mailsrv.i.zmi.at", Issuer "mailsrv.i.zmi.at" (not verified)) by mailsrv1.zmi.at (Postfix) with ESMTP id DD53ACC8 for ; Tue, 5 Feb 2008 22:22:38 +0100 (CET) Received: from saturn.i.zmi.at (saturn.i.zmi.at [10.0.0.2]) by mailsrv.i.zmi.at (Postfix) with ESMTP id A5FF5BEE6 for ; Tue, 5 Feb 2008 22:22:46 +0100 (CET) From: Michael Monnerie Organization: it-management http://it-management.at To: pgsql-admin@postgresql.org Subject: Re: PG 8.2 change Letter Sort Order Date: Tue, 5 Feb 2008 22:22:33 +0100 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) References: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1836943.c7TyCHRdFT"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802052222.37515@zmi.at> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/40 X-Sequence-Number: 28114 --nextPart1836943.c7TyCHRdFT Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Dienstag, 5. Februar 2008 jkohlmeier@pronet-systeme.de wrote: > I need a sort where =DF=3D=3Dss and =E4 =3D=3Dae. If you find a solution, I would be interested, too. mfg zmi =2D-=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4 --nextPart1836943.c7TyCHRdFT Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQBHqNOdzhSR9xwSCbQRAo9lAJ9Odrps4Mh86pnfFLmfwvE54hoSOQCgsieC 8VqjcByxV2mff2cPzV5/pSA= =pyVc -----END PGP SIGNATURE----- --nextPart1836943.c7TyCHRdFT-- From tgl@sss.pgh.pa.us Tue Feb 5 21:41:32 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6FD402E3F44 for ; Tue, 5 Feb 2008 17:41:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92462-04 for ; Tue, 5 Feb 2008 17:41:26 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id AA23C2E2DCC for ; Tue, 5 Feb 2008 17:41:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m15LeFo9028288; Tue, 5 Feb 2008 16:40:15 -0500 (EST) To: Michael Monnerie cc: pgsql-admin@postgresql.org Subject: Re: PG 8.2 change Letter Sort Order In-reply-to: <200802052222.37515@zmi.at> References: <200802052222.37515@zmi.at> Comments: In-reply-to Michael Monnerie message dated "Tue, 05 Feb 2008 22:22:33 +0100" Date: Tue, 05 Feb 2008 16:40:15 -0500 Message-ID: <28287.1202247615@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/42 X-Sequence-Number: 28116 Michael Monnerie writes: > On Dienstag, 5. Februar 2008 jkohlmeier@pronet-systeme.de wrote: >> I need a sort where ß==ss and ä ==ae. > If you find a solution, I would be interested, too. What you'd need is a locale definition that acts that way. If that is a common understanding of the meaning of sorting in German, I'd imagine someone has made one up --- but a PG list is the wrong place to be asking about it. We just use the operating system's locale facilities, we don't write our own. You'd want to find some libc or libintl hackers ... regards, tom lane