[OFBIZ-4535] Search using Russian word (maybe others) causes distortion and failed product search

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: Release Branch 12.04, Trunk
• Component/s: ecommerce

Environment

Ubuntu and others.

• Assignee: Jacques Le Roux
• Reporter: mz4wheeler
• Created: 31/Oct/11 04:16
• Updated: 30/Mar/15 07:24
• Resolved: 04/Feb/14 18:10

Description

NOTE: The following post contains UTF8 characters.

After rebuilding keywords in a UTF8 database (postgres) and searching a UTF8 browser (chrome), the Russian phrase is correctly present in the database, as follows:

ofbiz=# select * from product_keyword where keyword = 'игроков';
product_id | keyword | relevancy_weight (trimmed)
---------------------------------------
DVDMV-ADVANGYM | игроков | 1

However, when pasting 'игроков' into ecommerce Search, the following is returned "Not Found"

Keywords: "Ð¸Ð³Ñ Ð¾ÐºÐ¾Ð²", where any word matches, which distorts the search.

This may affect other languages, which I haven't tested.

I also tried the same search in 12.04 (demo) and trunk and it produces the same issue. This means that multi-language product search is broken in OFBiz. 11.04 is unaffected.

Issue Links

• depends upon: OFBIZ-5312 Proposal: URL-Generation Changes (mostly for SEO reasons but not only)
• duplicates: OFBIZ-5035 Special characters (latin, accent ...) are in error from an input (search, contact us ...)