[ https://issues.apache.org/jira/browse/OFBIZ-4535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
mz4wheeler updated OFBIZ-4535: ------------------------------ 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. was: 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 9.04 (demo) and trunk and it produces the same issue. This means that multi-language product search is broken in OFBiz. > Search using Russian word (maybe others) causes distortion and failed product > search > ------------------------------------------------------------------------------------ > > Key: OFBIZ-4535 > URL: https://issues.apache.org/jira/browse/OFBIZ-4535 > Project: OFBiz > Issue Type: Bug > Components: specialpurpose/ecommerce > Affects Versions: SVN trunk, Release Branch 12.04 > Environment: Ubuntu and others. > Reporter: mz4wheeler > Attachments: r1127449-r1127394.diff > > > 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira