Sql query cannot handle special character like ½

[wengyao04]

Some of our string fields contain special characters like  ½. When we use get
API to retrieve the object from the cache by key, and print out the field
having special characters,  the special characters are displayed correctly. 

However, when we use SqlFieldsQuery to select the field like the following

 String sql = "SELECT id, shortName from Warrant where id = ?";
 QueryCursor<List&lt;?>> cursor = mycache.query(new
SqlFieldsQuery(sql).setArgs("id1235"));
List<List&lt;?>> rows = cursor.getAll();
for (List<?> row : rows) {
    System.out.println(row.get(0) + " " + row.get(1));
}

The special character does not decode correctly, it shows "?" instead of "½"

How could we fix this problem when using SqlFieldsQuery  to query string
field containing special character ?

Thanks



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/