Brian Candler wrote:
> - In Oracle, "like" is case-sensitive (only)
> - In Sqlite, "like" is case-insensitive (only)
> - In Mysql, you have the choice of "like" or "ilike" operators
> 
> It's pretty much impossible to layer consistent semantics on top of all
> three databases. I have had to approximate. In the case of Oracle, I have to
> issue queries of the form
> 
>      "foo like ? or foo like ? or foo like ? or foo like ?",
>          var, var.downcase, var.upcase, var.capitalize

I know this is offtopic, but you could probably use "UPPER(foo) LIKE 
UPPER(?)" on all 3 databases... :)

Regards,

Peter