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 _______________________________________________ SQLiteJDBC mailing list [email protected] https://lists.hcoop.net/listinfo/sqlitejdbc
