[SQLiteJDBC] SQLiteJDBC Digest, Vol 10, Issue 1
Gary Helmstetter
gh at theworld.com
Sat May 1 23:15:27 EDT 2010
On May 1, 2010, at 12:00 PM, sqlitejdbc-request at lists.hcoop.net wrote:
> Send SQLiteJDBC mailing list submissions to
> sqlitejdbc at lists.hcoop.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.hcoop.net/listinfo/sqlitejdbc
> or, via email, send a message with subject or body 'help' to
> sqlitejdbc-request at lists.hcoop.net
>
> You can reach the person managing the list at
> sqlitejdbc-owner at lists.hcoop.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of SQLiteJDBC digest..."
>
>
> Today's Topics:
>
> 1. Case sensitivity differs from console
> (Carlos Eduardo Moreira dos Santos)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 30 Apr 2010 19:09:57 -0300
> From: Carlos Eduardo Moreira dos Santos <cems at cemshost.com.br>
> Subject: [SQLiteJDBC] Case sensitivity differs from console
> To: sqlitejdbc at lists.hcoop.net
> Message-ID:
> <i2uf85413c91004301509scd4377f1o61e6d4d61a9fcbf9 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> 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
First, for reference read the "The LIKE and GLOB operators" section of:
http://www.sqlite.org/lang_expr.html
My guess is that the difference in behavior may be caused by a
difference in which sqlite your "console" was built with, versus the
one your SQLitejdbc was built with. Regardless, here is my suggestion
for working around the problem:
SELECT * FROM cities WHERE LOWER(name) LIKE '%london%';
- Gary H
More information about the SQLiteJDBC
mailing list