Mail body search doesn't work with non-latin characters
Open
Nobody has claimed this yet.
1. to develop
bug
- Dominant language
- JavaScript
- Stars
- 1k
- Forks
- 348
- Avg merge
- 12h 28m
- Merged PRs (30d)
- 91
Description
Steps to reproduce
- Make sure there's at least one mail with non-latin text in it (e.g. hangul or cyrillic) in your mailbox
- Try to find this letter by its body text using simple or advanced search
Expected behavior
Search query returns email with corresponding text
Actual behavior
Search query returns no results
Mail app version
3.6.0-alpha.3
Mailserver or service
Zimbra
Operating system
Windows 10
PHP engine version
PHP 8.2
Web server
Nginx
Database
PostgreSQL
Additional info
Thanks to https://github.com/nextcloud/mail/pull/8897 now we have mail body search, but it seems that it works correctly only with latin characters.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reading the mail body search introduced in pull request #8897 and reproduce the issue with Hangul or Cyrillic text against PostgreSQL. Trace the search path for simple and advanced queries; done means both return the matching message body for non-Latin text.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php, postgresql
- Domain
- backend, databases, search
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100