When using a Node Browser cmis-alfresco search certain characters appear to be interpreted as wild cards:
As an example, a folder exists in Alfresco named ANameFollowedbyaChar“SecondName.Given “ is an illegal search (results in 09170367 line 1:42 no viable alternative at character '“'), this is replaced in the search with _x20ac_
SELECT cmis:path FROM cmis:folder WHERE IN_TREE('AFolder' ) AND CONTAINS('cmis:name:ANameFollowedbyaChar_x20ac_SecondName*')
the search locates the folder , but would also locate a folder with a similar name, e..g ANameFollowedbyaChar€SecondName.
The search appears to be using _x20ac_ as a wildcard. This behavior is consistent when search for several non standard chars.e.g when using values “ (_x20ac_) , € (_x201c _) , -(_x002D_) in the search statement , the folder ANameFollowedbyaChar“SecondName would be located.
Why is the search treating these values as a wildcards ?