Author Topic: VM search Garbled characters for Japanese  (Read 192 times)

tarousama

  • Beginner
  • *
  • Posts: 2
  • A beginner
VM search Garbled characters for Japanese
« 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.

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3408
  • using Matomo instead of Google Analytics
Re: VM search Garbled characters for Japanese
« Reply #1 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.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

tarousama

  • Beginner
  • *
  • Posts: 2
  • A beginner
Re: VM search Garbled characters for Japanese
« Reply #2 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.