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...