3279640 - Flexiblesearch query return empty result if query parameter including NON-ASCII character

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.

SAP Commerce Cloud all versions

unicode,Flexiblesearch, ccv2 , KBA , CEC-SCC-PLA-PL , Platform , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.