hibernate - how to escape colon in HQL -


i have condition part of query follows:

... foo.bar '%:%' 

the query execute no result. think it's because of colon since reserved char in hql. how can escape without sending : parameter query.

i have used '%\:%' , '%\\:%' no success.

i found solution: q=q.replaceall(":","'||unistr('\\003a')||'");


Comments