Hi, When i search on field in MMBase, i would like to take the special characters into account. For instance when i search on "Yes" i would also like to find "Y�s", "Y�s", "Y�s" and "Y�s".
My first approach was to search on "Y_s". This does nor work, since �, �, � and � are represented in the database by a two character sequence. So in order to find "Y�s", "Y�s", "Y�s" and "Y�s", i had to search on "Y__s" (= Y,underscore,underscore,s ). When tryin to find "Yes" and all of its mutations, one has to search both on "Yes" and "Y__s". For one word this solution becomes already cumbersome. For instance consider searching on "development" one has to use: developement, d__velopement, dev__lopement, etc, etc (= 32 possibilities). The only workable solution i came up with was searching on "Y%s", but the drawback of course is that also sentences like "You bet i can find this" are returned as solutions. Did anybody tried to solve the same problem? Does anybody has a suggestion? Thanks in advance, Kind regards, Henk. T. +31-(0)6-29054903 E. [EMAIL PROTECTED] I. http://www.mmatch.nl
