We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Does the forum search supports Chinese language? (Answered) | Forum

Topic location: Forum home » Support » General Questions
olalala
olalala Nov 17 '13

I have tried and  it only works for English. 

and i cant find any solutions here.

does anyone know how to solve it? 


thanks

The Forum post is edited by ross Nov 18 '13
ross Team
ross Nov 18 '13
The search feature in the forum looks for the same words in the content of the post, please make sure that there are the same words in the content
olalala
olalala Nov 18 '13
Quote from ross The search feature in the forum looks for the same words in the content of the post, please make sure that there are the same words in the content

I tried again and find out that the search works for the exactly same words between punctuation or blanks
 in content. 

Chinese words are different from other languages.

the words in Chinese are not separate by blanks.

so i think the problem is that the search can't recognised the words in one phrase or part of the phrase.








Daniel
Daniel Nov 18 '13
Unfortunately the search doesn't seem to support wildcards (*) so I don't think there's an easy workaround.

As Oxwall uses a standard MySQL database in the backend, maybe there is something you could do there. The forum posts are stored in Unicode (UTF-8) with "general" collation. I don't know if it would help to use Big5 encoding instead, or if that doesn't influence the search. Maybe there is also a possibility to rebuild fulltext search indeces in a way that makes it usable for CJK scripts. Someone with more MySQL experience (or some googling) could tell you if that's possible.

Otherwise there would be no way around modifying the forum script. Wildcard searches are no problem for MySQL databases with fulltext indices. So one possibility might be to modify the search function so that it always uses wildcards for the database query.
olalala
olalala Nov 18 '13
Quote from Daniel Unfortunately the search doesn't seem to support wildcards (*) so I don't think there's an easy workaround.

As Oxwall uses a standard MySQL database in the backend, maybe there is something you could do there. The forum posts are stored in Unicode (UTF-8) with "general" collation. I don't know if it would help to use Big5 encoding instead, or if that doesn't influence the search. Maybe there is also a possibility to rebuild fulltext search indeces in a way that makes it usable for CJK scripts. Someone with more MySQL experience (or some googling) could tell you if that's possible.

Otherwise there would be no way around modifying the forum script. Wildcard searches are no problem for MySQL databases with fulltext indices. So one possibility might be to modify the search function so that it always uses wildcards for the database query.
Thanks for suggestions. I will keep trying. 
Patrick
Patrick Apr 17 '17
I am also upset that OXWALL doesn't support Chinese (and CJK) search. Do you have solution about this? (e.g. 3rd party plugin)