VirtueMart Forum

VirtueMart 2 + 3 + 4 => Language/Translations => Topic started by: tarousama on January 25, 2019, 09:35:57 AM

Title: VM search Garbled characters for Japanese
Post by: tarousama on January 25, 2019, 09:35:57 AM
Hi
I have an Virtuemart installed in "English" and am translating content into "Japanese".

However...I just tested a search....typing "English" works fine...

But The "Japanese" search results Garbled characters. Does anyone have any type of hack/tweak/alteration to fix this issue?
Multilingual Virtuemart is nice, but so very limited if search functions in different languages won't work.
Or is there a search module that supports multiple languages?

Any advice would be greatly appreciated.
Title: Re: VM search Garbled characters for Japanese
Post by: jjk on January 26, 2019, 00:02:07 AM
Do search results for Joomla content show garbled characters, too? I suppose you might have to change the standard database collation of the VirtueMart tables. Probably they use the utf8_general_ci collation. I never tried Japanese, but probably the utf8mb4_general_ci or utf8mb4_unicode_ci collation will cover Japanese better.
The collation can easily be changed with phpmyadmin.
Title: Re: VM search Garbled characters for Japanese
Post by: tarousama on January 30, 2019, 10:20:16 AM
Thank you very much for your advice.
yes,search results garbled as below.
%E3%83%86%E3%82%B9%E3%83%88
I am trying to change the table.

thank you again.