Hi!
I am having a strange problem can someoneplease explain...

I create a table

CREATE TABLE TEST (TEST C(121)) (or more)
SET COLLATE TO 'GERMAN'
INDEX ON TEST TAG TEST  Invalid Key Length

But
SET COLLATE TO 'MACHINE'
INDEX ON TEST TAG TEST (ok)

Works fine....
If I make the table with length 120 it works fine....


What I want to do is make sure that the 'ä' are ordered properly for germans when they search the database...

Is there another way of doing this or am I just missing something....



Thanks...