Bookstack: Chinese search cannot find words in the middle of a sentence.

[jasoncheng7115]

For Bug Reports

• BookStack Version: v0.20.0

When the word I'm looking for is the first word, or there's a space in front of it, it's ok.

But if the word is in the middle of a sentence, it cannot be found.

Whether this is a full-text retrieval of related issues?

Thanks!

[alexwyl]

The same problem in version: v0.25.1, I have just tried BookStack...

[lotustalk]

The same problem in version: v0.24.3, I use a docker

[linpengxuan]

still the same problem in v26.4. hope it could get solved. thanks

[sosize]

you can use "成功" for search, maybe the word segmentation has the bug, hope fix it

[LeonLiuY]

Confirmed this issue still in v0.27.5
One of my team member is hesitating because of this. Would like to see it fixed.

[hlj]

Hope fix this issue soon.

[ssddanbrown]

Sorry about this issue. It essentially stems from my unfamiliarity with non-English text.

At the moment BookStack splits up page content, on certain characters such as spaces and some punctuation, into terms which are put in the database for indexing then a "Starts With" match of those are checked against on a normal search.

As @sosize has mentioned, you can wrap a search in quotes, at which point BookStack will perform a "contains" against the content directly instead of the above "Starts With". This is not the default simply due to performance. ("Starts With" searches can use indexes much more effectively than "Contains").

I'm not really sure how we could utilise the "Starts With" system for such characters. Perhaps the search should default to a "Contains" search if such characters are found in a term?

[sosize]

@ssddanbrown Can this be set as config control ？Select “Starts With” or “Contains” for search type.

More is hope full-text search.

Or how to quickly modify the code?

[lishuai199502]

can i replace all the "startWith" with "contains",or how to modify the source code ,sorry ,i'm a noob

[lishuai199502]

Hi,all the guys,I fixed this problem in v0.28.3.Just add a '%' in SearchService.php.
In detail.
in \app\Entities\SearchService.php,about line 196.
modify
$query->orWhere('term', 'like', $inputTerm . '%');
to
$query->orWhere('term', 'like', '%'.$inputTerm . '%');
Just try.

[kt1024]

@ssddanbrown hi, can above fix be merge to the source?
after modify SearchService.php now I can search both chinese and english in text body.