Symptom
In CCV2, Flexiblesearch query return empty result if query parameter including NON-ASCII character.
For example there is a product in database which name is Chinese characters, such as '测试'.
But if you search the product either by running the below Flexibleserarch query directly in HAC
select * from {product} where {name[zh]} ='测试' |
or running the FlexibleSearch query by the below Groovy script
import de.hybris.platform.servicelayer.search.FlexibleSearchQuery; final FlexibleSearchQuery query = new FlexibleSearchQuery ("SELECT {PK} FROM {product} where {code}='测试'"); result = flexibleSearchService.search(query); println result.getResult(); |
It will return an empty result in both ways.
Read more...
Environment
- Product version: All SAP Commerce Cloud versions
Product
Keywords
unicode,Flexiblesearch , KBA , CEC-SCC-PLA-PL , Platform , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.