Problem searching Chinese Text in VB4

[lance77]

hi everyone,

i'v managed to make the necessary modifications to enable chinese text encodings via the following methods
(1) setting my database to UTF8 encoding
(2) vbulletin-language.xml to UTF8
(3) config.php set "$config['Mysqli']['charset'] = 'utf8';"
instructions all stated here
did all of above in fresh install...

i even followed additional instructions to make sure the chinese text come out alright
according to recommendations here


but one last big problem,

any chinese text i'v made in the posts and threads are not captured for keyword search....

i.e. if i search for the chinese text, nothing shows up.


does anyone know how to solve this problem?

[lance77]

here's a more specific detail that might help solve the problem.

the posts i made in my forum : http://www.beijingcp.com.cn contains both chinese and english texts and phrases.

whenever i search for existing english text, it works...

but when i search for chinese text: the error message goes

"The following words are either very common, too long, or too short and were not included in your search: "

is there anyway to circumvent this problem?

[Ramsesx]

I have a german board (utf-8) and created a post containing chinese words and with chinese title, did a search and all is found well.

[lance77]

thanks Ramsesx,

my question would be - what did you do right and what did i do wrong?

i'll need to know specifically where it went wrong so we can fix it.

[Ramsesx]

Ok, I saw your text is an cms article thought you mean forum posts. So I tried to search in your site and found out you need to do an advanced search and tick "Search Type" to "any type" it's finding the article. Seems the default search in the normal search is only searching in forums. On my site articles are found by default. Maybe there's a setting in acp to customize the search?

[lance77]

Thanks for helping, Ramsesx,
appreciate it. but the problem seems more complex

(1) see this thread which is posted in forum (it's also promoted as an article)

http://www.beijingcp.com.cn/showthread.php?4-1月16日－-模特棚拍精品小班&highlight=模特棚拍精品小班

if i search for "模特棚拍精品小班"
which is 8 chinese characters listed in the thread's subject header, it works.
but if i reduce it to just by one character, say "模特棚拍精品小" (without the "班")

there's no matches.

(2) on the other hand, if i search for another string of 8 characters in the thread's main body text,
example "北京市朝阳区建外"
it doesn't work.

from above observations, it looks like

(a) search only works if it's eight chinese characters or more, and only if it's found in the subject header
(b) chinese text in the main body text are not searchable

[Ramsesx]

To (1), have you looked in acp, there is a setting for the minimum character needed for searching, maybe you have set it to 8 characters?
The other issue is beyond my knowledge, maybe you could try to change the search options in acp to db search if not yet enabled.
But I think you should open a support ticket. Good luck. (B.t.w. nice image in your thread)

[lance77]

Thanks Ramsesx,

reduced the minimum character needed from 4 to 2 (upon your advice)

the search option is already "dbsearch" that's the only option available

i just opened a support ticket, upon your advice.

I'v also asked a few professionals (via paid services) for help, a couple mentioned that this is a bug within vbulletin itself and they suggested asking vbulletin crew to fix it instead of getting them to do it...