I mean
1. convert your string to lowercased text
2. search for lowercase at the database
3. create proper indices on the database
sorry
On Jul 11, 5:31 pm, paramedic <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
