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