In Ormlite, write case insensitive query?

Right now (May 2011) there is no mechanism to do this with ORMLite except for writing the actual SQL and using the queryRaw() and other raw methods.

Right now (May 2011) there is no mechanism to do this with ORMLite except for writing the actual SQL and using the queryRaw() and other raw methods. In many databases, MySQL for example, case insensitivity looks to be the default. But this is not the case with Postgresql nor Oracle.

A quick look around at the various database implementations shows that there is not a very easy and portable way to do this. Am I wrong?

I am answering my own question, but the following seems to work. NewDao. Query(newDao.queryBuilder().where().

Like("nameColumn", "finance") .prepare()) Above seems to return all "finance", "Finance", "FINANCE" or any other variations of it.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.