Case insensitive LIKE operations also differ across databases, with PostgreSQL using ILIKE, some other databases being case insensitive by default, and the H2 embedded Java database requiring a cast.