[SQLiteJDBC] Case sensitivity differs from console

[Carlos Eduardo Moreira dos Santos]

Hi,

I'm trying to do a case-insensitive like search:
SELECT * from cities WHERE name LIKE '%london%';
It works fine in console, but using java the like becames case
sensitive. I tried to use lower function, but it doesn't work. I'm
wondering if there is a way to specify ASCII encoding to query when
using jdbc.

Thank you,
Carlos Eduardo