Search code examples
javaandroidsqliteandroid-sqlite

How to get my desired results in Android Sqlite Search LIKE % where search key word in bangla language

  1. cursor = sqLiteDatabase.query(MyTableName, allColumns, Database.COLUMN_TO + " LIKE ?", new String[]{"%বিবেচন%" }, null, null, null);

myMeaning="বিবেচন";

  1. cursor = sqLiteDatabase.query(MyTableName, allColumns, Database.COLUMN_TO + " LIKE ?", new String[] {"%"+myMeaning+"%"}, null, null, null);

The first gives my desired result. I want to know why the second one can not give the desired result?

Solution

  • Solved, problem was in myMeaning variable which is myMeangin="বিবচন"; not "বিবেচন"