SAP Knowledge Base Article - Preview

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

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

SAP Commerce Cloud all versions

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.