[web2py] Re: search with like/contains & case sensitive

2014-09-26 Thread Niphlod
DAL doesn't do any magic, it just passes along commands (that you can inspect in various ways, such as db._lastsql or using _select() instead of select()). You'll have to fiddle with your own database collation to make SELECT field FROM table WHERE LOWER(field) LIKE '%whatyouwant%' returns the

[web2py] Re: search with like/contains & case sensitive

2014-09-25 Thread Vladimir Makarov
*For cyrillic types I mean for example words in russian language.* On Thursday, September 25, 2014 9:44:31 PM UTC+3, Niphlod wrote: > > what do "cyrillyc types" mean ? > > On Thursday, September 25, 2014 8:27:55 PM UTC+2, Vladimir Makarov wrote: >> >> Give me a clue of how to set my search case i

[web2py] Re: search with like/contains & case sensitive

2014-09-25 Thread Niphlod
what do "cyrillyc types" mean ? On Thursday, September 25, 2014 8:27:55 PM UTC+2, Vladimir Makarov wrote: > > Give me a clue of how to set my search case insensitive for all kind > types?!? > > def search(): > lname = request.vars.name #form field > q = db.tbl.l_name.like('%'+str(lname)+