[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL => DAL not portable

[KMax]

On 29 янв, 05:39, Bernd Rothert <roth...@googlemail.com> wrote:
> On 28 Jan., 16:46, Thadeus Burgess <thade...@thadeusb.com> wrote:
>
> > Case sensitive search is one of the benefits of using postgres instead of
> > mysql!
>
> As Fran wrote case insensitive LIKE is just a default for MySQL and
> sqlite. MySQL supports case sensitive search:
This make .like() for mysql work not same as PG, etc...
>
> # SELECT * FROM person WHERE name LIKE BINARY '%Pi%';
>
> sqlite3's LIKE can be configured with "PRAGMA
> case_sensitive_like=yes".

Is't a way to add .ilike() for case insensitive select?
Anyway .like() for mysql should be adjusted to be case sensitive,
if .ilike() will be implemented.
Is'nt it?