Just set case_sensitive=False and it will work exactly the way you want regardless of the convention chosen. I now set the case on my queries since it seems prudent to do so. After all, I may change from Postgres to MySql or something and I don't want to be surprised.
-- Joe On Thursday, September 11, 2014 7:46:17 PM UTC-7, Leonel Câmara wrote: > > Nothing is exactly broken, but autocomplete uses "like" in its queries > when it's not running on gae, so, once this is decided, we need to either > set it case_sensitive=False or make it use ilike (so it has the same > behaviour on gae and other adapters) > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.