Subject Search not accepting umlauts

[Tarboy3000]

Given an email with a subject like
A subject with umlauts: Ä Ö Ü
searching via the query
subject:"Ä"
does not return the correct emails

Non-prefixed search seems to work with umlauts (which is the workaround I'm using currently), so searching Ö returns emails as expected.

[axllent]

I can confirm the bug, thanks for reporting it.

[axllent]

It turns out this is a limitation of SQLite, and there is no ideal solution as the embedded SQLite Mailpit uses (to provide multi-platform support) does not include the ICU extension (I do not think it is possible).

SQLite only understands upper/lower case for ASCII characters by default. The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.

General searches are not affected as the search index Mailpit creates is lowercased by Mailpit before storing it in the database, and the search is (or rather was) lowercased before searching, however when searching by a specific field (eg subject:"Ä") a match would not be found unless the subject contained a lowercase "ä".

I have added a work-around which now assumes the searched unicode character matches the case of unicode character in the subject field. General searches (that don't specify a field) are not affected by this as everything is lowercased, however subject, to, from etc are stored in their original case in the database. This will be included in the next release.

[axllent]

@Tarboy3000 This workaround has been included in v1.13.1. I'll mark this issue as resolved (as much as it can be for the reasons I mentioned before regarding unicode characters and SQLite), however if you experience any issues caused by this then please let me know. Thanks.