Dear professionals,

I have 2 languages on my website. English and Arabic.
When I first created the database/data entries, I typed all the brands names in English with the corresponding brands names in Arabic for each one.
Now, when i'm in the Arabic frontend and I search for any listing using English keywords no listings appears although there are listings to the related topic.

ِِِAnd the same goes when I'm on the English frontend when trying to search using Arabic keywords.
Usually some of the users prefer the English forntend but do search in Arabic (as myself) and some do the other way round.

Could you please help so the search looks for the word and its corresponding word in the same time, in other words to search for the word SONY it looks for "SONY" and "zzxxyy" (assuming zzxxyy is the corresponding word to SONY but in another language) and shows the listings that contains "SONY" and/or "zzxxyy".

Your efforts are highly appreciated,

Ammar,