advplyr / audiobookshelf

Self-hosted audiobook and podcast server
https://audiobookshelf.org
GNU General Public License v3.0
5.52k stars 380 forks source link

[Bug]: Search results are too strict resulting in no results found. #2987

Closed KellicTiger closed 2 weeks ago

KellicTiger commented 2 weeks ago

What happened?

Uncertain if this would be a "bug" or a feature request. Also I did search issues for this and didn't see any other mentions. So I HOPE that this isn't a duplicate like the last submission I did.

I have the audio book Shōgun by James Clavell. When doing a search from either the web interface or the Android client for shogun no results are found. image

https://en.wikipedia.org/wiki/Ch%C5%8Donpu The chōonpu (Japanese: 長音符, lit. "long sound symbol"), also known as chōonkigō (長音記号), onbiki (音引き), bōbiki (棒引き), or Katakana-Hiragana Prolonged Sound Mark by the Unicode Consortium, is a Japanese symbol that indicates a chōon, or a long vowel

If you use the special character the results show. (Which I will be honest I have no idea how to get from either the Google Keyboard or my desktop character set, I had to copy and paste from an example on a webpage.)

image

What did you expect to happen?

The search should be a bit looser when it comes to results. e.g.
ā = a ī = i ū = u ē = e ō = o

Steps to reproduce the issue

  1. Add a title that has one of these special characters in the title.
  2. Search on it without using special characters.

Audiobookshelf version

v2.9.0

How are you running audiobookshelf?

Other (list in "Additional Notes" box)

What OS is your Audiobookshelf server hosted from?

Other (list in "Additional Notes" box)

If the issue is being seen in the UI, what browsers are you seeing the problem on?

Firefox

Logs

No response

Additional Notes

Environment:

Server: QNAP TVS-H1288X Package from https://www.myqnap.org repository run on the NAS, not in a container.

Client: Fedora 39 - Web interface Firefox v126 Android 14 (Samsung Fold4) - Audiobookshelf v0.9.73-beta

nichwall commented 2 weeks ago

https://github.com/advplyr/audiobookshelf/issues/1401

Adding a fuzzy search should help with this. Part of the problem is that searches are done by converting to lowercase, but non-ASCII characters do not have a "to lowercase" in SQLite. (Mentioned in https://github.com/advplyr/audiobookshelf/issues/2187#issuecomment-1749685811 and https://github.com/advplyr/audiobookshelf/issues/2234)

advplyr commented 2 weeks ago

Duplicate of https://github.com/advplyr/audiobookshelf/issues/2678