Hi Thomas,

thanks for this.
I will try this, cause it seems to be the real answer to my question.

Uwe

Thomas von Stetten wrote:

> Hi Peter,
>
> >Which FB code page is the best to use for German character sets?<
>
> I think you should use WIN1252 and COLLATE PXW_INTL or PXW_INTL850 because
> with ISO8859_1 and DE_DE some values get ordered incorrect. Excaples:
>
> ISO8859_1 DE_DE WIN1252 PXW_INTL WIN1252 PXW_INTL850
> -----------------------------------------------------------
> 'ABC E30' 'ABC E30' 'ABC E30'
> 'ABC E300/800' 'ABC E30 ab V2.2' 'ABC E30 ab V2.2'
> 'ABC E30 ab V2.2' 'ABC E300/800' 'ABC E300/800'
> ==> ' ' > '0'?
>
> 'äaa' 'aea' 'aea'
> 'ÄAA' 'AEA' 'AEA'
> 'Ächter 2' 'äaa' 'äaa'
> 'Ächter 3' 'ÄAA' 'ÄAA'
> 'aea' 'Aechter 1' 'Aechter 1'
> 'AEA' 'Aechter 2' 'Ächter 2'
> 'Aechter 1' 'Ächter 2' 'Aechter 2'
> 'Aechter 2' 'Aechter 3' 'Ächter 3'
> 'Aechter 3' 'Ächter 3' 'Aechter 3'
> ==> 'Ä' sorted with the same "weight"(?) as 'AE' - thats what users expect
>
>
> Thomas