[GH-ISSUE #276] There is some problem in search with chinese #201

New issue

Open

opened 2026-02-25 23:33:41 +03:00 by kerem · 4 comments

kerem commented

2026-02-25 23:33:41 +03:00

Owner

Originally created by @zero47 on GitHub (Sep 3, 2020).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/276

Title: macOS 免费小工具
In keyworks:

macOS √
免费 √
免费小工具 ×

Originally created by @zero47 on GitHub (Sep 3, 2020). Original GitHub issue: https://github.com/go-shiori/shiori/issues/276 Title: macOS 免费小工具 In keyworks: 1. macOS √ 2. 免费 √ 3. 免费小工具 ×

kerem added the

type:bug

component:backend

database

labels

2026-02-25 23:33:41 +03:00

kerem commented

2026-02-25 23:33:41 +03:00

Author

Owner

@wadefelix commented on GitHub (Feb 8, 2022):

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

@wadefelix commented on GitHub (Feb 8, 2022): mariadb 不支持中文全文索引导致的

kerem commented

2026-02-25 23:33:41 +03:00

Author

Owner

@fmartingr commented on GitHub (Feb 10, 2022):

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?

@fmartingr commented on GitHub (Feb 10, 2022): > 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?

kerem commented

2026-02-25 23:33:41 +03:00

Author

Owner

@natsukium commented on GitHub (Oct 1, 2022):

I’m using PGroonga, a PostgreSQL extension, to use FTS in Japanese.
https://github.com/go-shiori/shiori/compare/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

@natsukium commented on GitHub (Oct 1, 2022): I’m using [PGroonga](https://pgroonga.github.io/), a PostgreSQL extension, to use FTS in Japanese. https://github.com/go-shiori/shiori/compare/master...natsukium:shiori:groonga It also supports Chinese. For MariaDB, there is also an extension, [Mroonga](https://mroonga.org/). 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

kerem commented

2026-02-25 23:33:41 +03:00

Author

Owner

@fmartingr commented on GitHub (Oct 3, 2022):

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.

@fmartingr commented on GitHub (Oct 3, 2022): 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.

kerem referenced this issue

2026-02-25 23:34:38 +03:00

[PR #202] [MERGED] Fix: Bookmark content displays Invalid Date if database is PostgreSQL #535