[FEATURE] Allow ignore tildes and special characters on search

[nico2sh]

Is your feature request related to a problem? Please describe.

It would be great to be able to search ignoring tildes, when I search both in the search box and in a script, I have to type exactly how it was written (ignoring uppercase though), so if I'm looking for something like:

Avion means plane in Spanish

I get zero results if the actual text is

Avión means plane in Spanish

Describe the solution you'd like

In search, use these character mappings for example:

• á=a
• é=e
• í=i
• ó=o
• ú=u
• ñ=n
• ç=c
  ...more?

[pbek]

This looks like a sqlite collate question. I guess someone would need to research and then try how this could be achieved with sqlite and Qt.

[pbek]

This is how the in-memory note table currently is created:

https://github.com/pbek/QOwnNotes/blob/253a9ab5f7f67b45e5a17ffcde5845f277c45dec/src/services/databaseservice.cpp#L421C25-L438

[pbek]

And this is one part of the search function:

QOwnNotes/src/entities/note.cpp

Lines 852 to 872 in 253a9ab

	QVector<Note> Note::search(const QString &text) {
	QSqlDatabase db = QSqlDatabase::database(QStringLiteral("memory"));
	QSqlQuery query(db);
	QVector<Note> noteList;
	query.prepare(
	QStringLiteral("SELECT * FROM note WHERE note_text LIKE :text "
	"ORDER BY file_last_modified DESC"));
	query.bindValue(QStringLiteral(":text"), QStringLiteral("%") + text + QStringLiteral("%"));
	if (!query.exec()) {
	qWarning() << __func__ << ": " << query.lastError();
	} else {
	for (int r = 0; query.next(); r++) {
	noteList.append(noteFromQuery(query));
	}
	}
	return noteList;
	}

[nico2sh]

Thanks for pointing out to the right direction. From the sqlite docs, no case unicode characters search is not supported but the NOCASE collation can be overriden. One can register their own collating sequence.
My C++ is very rusty to figure out if that or how that can be done :/

[pbek]

One can register their own collating sequence.

Hm, even if that would work with Qt, I guess that might cause a lot of regressions.