Like case sensitive in room persistence library

Question

How to apply case sensitive with LIKE query when use room persistence library android??

using below query

@Query("SELECT * FROM category WHERE category_name LIKE '%' || :categoryName|| '%'")
List<Category> getAllCategory(@Nullable String categoryName);

Use PRAGMA case_sensitive_like = on not working

Answer 1

By Help of pskink found answer:

Use GLOB instead of LIKE, Successful Query as below

@Query("SELECT * FROM category WHERE category_name GLOB '*' || :categoryName|| '*'")
List<Category> getAllCategory(@Nullable String categoryName);