Sling 7 JCR SQL Query Fails On Unicode-Value Properties

102 views Asked by At

I'm implementing a WCMS using Apache Sling 7.

In the tree I have some nodes with unicode values, for example,

I have a node with a property named pname('بابک بهزادی') and another node with pname('babak behzadi'). When I execute a query on pname field with unicode values query returns nothing:

select * from nt:unstructured where pname like '%بابک%'

but, if I execute the same query with non-unicode values it returns some results

select * from nt:unstructured where pname like '%babak%'

Queries above are SQL not SQL-2.

In addition, I've never had such a problem with Apache Sling 6.

EDIT:

Apache Sling works perfectly with these Jackrabbit bundles:

enter image description here

and fails with these bundles:

enter image description here

Any help is appreciated.

0

There are 0 answers