pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PG 8.2 change Letter Sort Order
3+ messages / 3 participants
[nested] [flat]

* PG 8.2 change Letter Sort Order
@ 2008-02-05 15:54  jkohlmeier@pronet-systeme.de
  0 siblings, 1 reply; 3+ messages in thread

From: jkohlmeier@pronet-systeme.de @ 2008-02-05 15:54 UTC (permalink / raw)
  To: pgsql-admin

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=de_DE.UTF-8 --lc-collate=de_DE.UTF-8 --lc-ctype=de_DE.UTF-8 -D DBPath

The Sort set with --lc-collate=de_DE.UTF-8 was not the right Sort Order ( ß=>ä=>aa=>äb). I need a sort where ß==ss and ä ==ae.
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 
PG 8.2

Thanks for Help

Jens

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PG 8.2 change Letter Sort Order
@ 2008-02-05 21:22  Michael Monnerie <michael.monnerie@it-management.at>
  parent: jkohlmeier@pronet-systeme.de
  0 siblings, 1 reply; 3+ messages in thread

From: Michael Monnerie @ 2008-02-05 21:22 UTC (permalink / raw)
  To: pgsql-admin

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.

mfg zmi
-- 
// 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

Attachments:

  signature.asc (application/pgp-signature, 193B) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PG 8.2 change Letter Sort Order
@ 2008-02-05 21:40  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Michael Monnerie <michael.monnerie@it-management.at>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2008-02-05 21:40 UTC (permalink / raw)
  To: Michael Monnerie <michael.monnerie@it-management.at>; +Cc: pgsql-admin

Michael Monnerie <michael.monnerie@it-management.at> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-02-05 21:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-05 15:54 PG 8.2 change Letter Sort Order jkohlmeier@pronet-systeme.de
2008-02-05 21:22 ` Michael Monnerie <michael.monnerie@it-management.at>
2008-02-05 21:40   ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox