4D v12 and 4D v11 SQL both support Unicode. As part of the Unicode standard there are certain characters that are considered "ignorable", meaning they should not be taken into consideration when performing comparisons, for example.

This code can be used to locate ignorable characters in 4D:

For ($i_l;1;65533)    $source_t:="x"+Char($i_l)    $pos_l:=Position(Char($i_l);$source_t)    If ($pos_l#2)       ` Ignorable character.    End if End for

As of 4D v11 SQL Release 8 (11.8) and 4D v12 there are 2,627 ignorable characters.

(Note: You can still use Position on "ignorable" characters, you just need to pass the * as stated in the documentation.)