From: "Asheesh" <firstname.lastname@example.org>
Subject: LIKE keyword in SQL query for Symbian Database doesn't support case-insensitive search.
Date: Monday, April 18, 2005 12:59 PM
I'm creating an application for UIQ platform in which I'm making extensive
use of Symbian DBMS APIs mainly using SQL queries.
I've created a view which allows users to search for data in the
application. For this I'm making use of the SQL LIKE keyword, under which
multiple words can be retrieved using the
wildcard character * .
Now the strange part I've come to know of is that LIKE keyword doesn't make
a case-insensitive search, it only makes a case-sensitive one.
Am I correct about this? If yes, it'd be really great if someone could
provide pointers as to how to overcome this limitation?
Any work-arounds,advices or suggestions would be extremely welcome.
My problem was solved by one of the guys. It was a matter of using
TDbQuery(const TDesC& aQuery,TDbTextComparison
the text comparison paramter instead of the default one. By using it, the search returned case-insensitive results...