Re: [ADMIN] german sort is wrong

2012-03-23 Thread BGoebel
Reinhard Asmus wrote > > when i make the same thing in oracle i've got > > Ätna > Anton > > > is it possible to get the same with postgresql and when how? > > PostgreSQLs collation support is not complete. Until now, you can not define a sort order of your own. Workaround: Step1: Def

Re: [ADMIN] german sort is wrong

2012-03-23 Thread Reinhard Asmus
Am 21.03.2012 14:51, schrieb Kevin Grittner: Reinhard Asmus wrote: when i make a sort this is the result: [vowel with umlaut sorts equal to vowel without] in german this is wrong. what is the problem? It appears to be one of three different "right" ways: http://en.wikipedia.org/wiki/G

Re: [ADMIN] german sort is wrong

2012-03-22 Thread Kevin Grittner
Reinhard Asmus wrote: > Am 21.03.2012 14:51, schrieb Kevin Grittner: >> Reinhard Asmus wrote: >> >>> when i make a sort this is the result: >> >>> [vowel with umlaut sorts equal to vowel without] >> >>> in german this is wrong. what is the problem? >> >> It appears to be one of three different "r

Re: [ADMIN] german sort is wrong

2012-03-22 Thread Reinhard Asmus
Am 21.03.2012 14:51, schrieb Kevin Grittner: Reinhard Asmus wrote: when i make a sort this is the result: [vowel with umlaut sorts equal to vowel without] in german this is wrong. what is the problem? It appears to be one of three different "right" ways: http://en.wikipedia.org/wiki/G

Re: [ADMIN] german sort is wrong

2012-03-21 Thread Kevin Grittner
Reinhard Asmus wrote: > when i make a sort this is the result: > [vowel with umlaut sorts equal to vowel without] > in german this is wrong. what is the problem? It appears to be one of three different "right" ways: http://en.wikipedia.org/wiki/German_alphabet#Sorting Is there a differ