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
-~----------~----~----~----~------~----~------~--~---
