There is some problem in search with chinese

[zero47]

Title: macOS 免费小工具
In keyworks:

1. macOS √
2. 免费 √
3. 免费小工具 ×

[wadefelix]

mariadb 不支持中文全文索引导致的

[fmartingr]

mariadb 不支持中文全文索引导致的

Thank you for stepping up, is this something than can be fixed or worked around application side, or it requires the user to switch to a different database engine?

[natsukium]

I’m using PGroonga, a PostgreSQL extension, to use FTS in Japanese.
master...natsukium:shiori:groonga
It also supports Chinese.
For MariaDB, there is also an extension, Mroonga.

If you use the database without these extensions, you need to modify the application code like the following.
Sorry for the Japanese blog.
https://www.clear-code.com/blog/2020/12/22.html

[fmartingr]

Hey @natsukium , thanks for the insights! If you are running this locally, have you noticed any caveheats running that extension? I'm unsure how many Shiori users require this in order to bundle it directly on our migrations or just provide a separate documentation page for people to install it on their own. Bundling it directly would require supporting it in all database systems, since want to provide the same features regardless of the database backend if possible.