search

turtl / tracker

This project is for tracking issues, bug reports, and progress on the entire Turtl project.
67 stars 3 forks source link

Search is case-sensitive for Cyrillics #358

Open merechance opened 4 years ago

merechance commented 4 years ago

I created a note with a Russian word "Тест". It can only be found if I type exactly "Тест" in the search field, not "тест", "ТЕСТ" etc

va-an commented 3 years ago

@merechance, I think it's because for searching using match from sqlite here in sources, and case-insensitive search operations in sqlite works only ASCII.

What I found about this (part of this in russian lang):

@orthecreedence, @rubbingalcoholic, please assign to me this issue, I would be interested to look into this issue.

orthecreedence commented 3 years ago

Assigned, and thank you! Keep in mind, it may be a limitation of the SQLite version we're statically linking against. Looks we're on version 3.31.0. It might be a matter of upgrading the rusqlite (in the main core project, and any of the child projects that use rusqlite, like clouseau). It could also have to do with extensions. Not sure. Hope that helps =].

va-an commented 2 years ago

@orthecreedence, hello! I'm so sorry, but my new exciting work don't let me time for this issue. Please unassigne me from ticket. Sorry again.