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

[Bernd Rothert]

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:

# SELECT * FROM person WHERE name LIKE BINARY '%Pi%';

sqlite3's LIKE can be configured with "PRAGMA
case_sensitive_like=yes".