Lars-Erik,
>
> The trailing spaces (and minimum sort characters) I have been removing
> so far, I have converted to the given character set, so for f.eks UCS2,
> I have been looking to remove 0x0020, etc
Whatever the representation for spaces is, that's what we can safely
remove. Everything else stays.
>
> Should it be done like this for trailing zeros as well, so that I in the
> case of ucs2 should be looking to remove 0x0000?
>
No - we remove trailings zeros on numeric keys only. Happily they
don't have collations.
Cheers,
Ann
