Hello,
i have a problem with the Formula “@Compare”. The accent insensitivity works not so exactly as I expected.
If I compare accent insensitive the “a” with “â”, or “a” with “á” they are for this function the same sign:
@Compare( “a”; “â”; [AccentInsensitive]) = 0 → as it should be.
But if I try to compare “a” with “ä” the same way, the function takes them as different signs:
@Compare( “a”; “ä”; [AccentInsensitive]) = -1 → there should be no difference.
Now imagine what happens in a vocabulary application if you expect to find a word beginning with “Ö”, “Ä”, or “Ü” under tab “O”, “A” or “U” but not under a tab opening the list of words beginning with special characters.
Has anybody an alternative or an idea how could I get a real accent insensitivity between “ä” and “a” or similar ?
Many thanks in advance and best regards,
Ionut