doing this is most suitable for my case in my oppinion. also there is a problem with the ascii issue.
In turkish the lowercase of I is ı however in in english the lowercase of I is i. I think I have to code it carefully :) I was thinking about turbolucene as it supports fuzzy search which is great for me, but I think I have to wait until turbolucene gets mature. On Jul 11, 4:55 am, Jorge Godoy <[EMAIL PROTECTED]> wrote: > On Tuesday 10 July 2007 11:52:43 paramedic wrote: > > > I am trying to add a search section in my tubogears web application. I > > want the search to be case insensitive try to use the like statement > > in sqlobject however I could not achive. > > > Also I am thinking about using turbolucene however my data in the > > database is collected by an external script from the web. Can I use > > turbolucene in this case? > > I don't know about the Lucene part, but for the database I recommend: > > 1. convert your string to lowercased text > 2. search for lowercase at the database > 3. create proper indices on the database > > What I have done when I need this functionality for some fields is converting > UTF-8 to ASCII (removing all diacriticals, converting special letters as > needed...) and indexing the lower() or the resulting column. It is worth, on > some cases, duplicating data to make this speedier. I do all that with a > trigger on the database, so this is all transparent to me and my code. I > just have to make a plain select and the database takes care of it all. > > -- > Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
