Django Watson can't search items with special characters with MySQL (UTF-8/InnoDB)

etianen / django-watson

Full-text multi-table search application for Django. Easy to install and use, with good performance.

BSD 3-Clause "New" or "Revised" License

1.2k stars 130 forks source link

Django Watson can't search items with special characters with MySQL (UTF-8/InnoDB) #237

Open kibershmiber opened 6 years ago

kibershmiber commented 6 years ago

Hi, guys!)) There is a big problem for me know with Watson(( Our searched items all contain "/" and "-" characters, and they can't be found through DW. With plain SQL they can be found perfect. What I should do in that case?

kibershmiber commented 6 years ago

Comooooone guys...

valentijnscholten commented 3 years ago

This is still a big issue, basically rendering the search powerless if you have '-' or similar in your titles (or contents)

valentijnscholten commented 3 years ago

Although it sounds like a bug in watson, it's more of a limitation of MySQL:

Easiest workaround is to put the search query (or the word with dashes inside the search query) inside double quotes. This won't fix everything but at least you will get the results.

etianen commented 3 years ago

I'd take a MR that you think fixes this.