Henk Hangyi <[EMAIL PROTECTED]> wrote: > Hi Michiel, > > Thanks for your reply. > > > I have never tried to solve it in MMBase. I have once solved it in a > > perl/mysql applications which involved storing everything twice (once > > completely stripped from accents to search in, and once the > > real string). > > Field-Types project might provide the means to implement a > > similar hack > > already. > > A combination of database search and search on a standardised field > might do the trick. > > For instance: > > When searching on "Yes": > 1. use a database to search on "Y%s", > 2. filter the resultset such that all the special characters are mapped > to their standard form, e.g. map all ?, > ?, ? and ? to e, > 3. use a Java search in the filtered resultset on "Yes". > > It doesn't sound that bad for performance. What do you think, should i > give it a try?
It is an option indeed. But actually, as I said, the problem is much more complex, and for a really good solution you would end up searching "%%%%%%" and performing the search in java, which would not be so good any more for another reason... Considering the language (dutch probably), it would perhaps be doable, as long as you don't require it to work also for 'foreign symbols' (haceks, cyrrilic etc) Also, using this solution the 'maxnumber' feature of the database cannot be used any more, or at least the result would not be correct any more. Perhaps, you would come away with this for your particalar site though. I'm not sure yet what to do for a generic solution. Michiel -- Michiel Meeuwissen Mediapark C101 Hilversum +31 (0)35 6772979 nl_NL eo_XX en_US mihxil' [] ()
