docs
docs copied to clipboard
Improve case sensitivity section for SQLite provider

This section's wording is a bit confusing on whether or not SQLite supports case-insensitive filtering or not. It should be clear that the default filtering mode is case-sensitive and that SQLite supports case insensitive only if your data is pure ASCII characters.
It's also not clear how I would actually use this workaround:
CREATE TABLE mytable (
sample TEXT COLLATE NOCASE /* collating sequence NOCASE */
);
So might be a good idea to include a resource that clarifies where to include this snippet
Found this as I have no idea how to use COLLATE NOCASE
As I'm needing this only for the name field for now I think I store a separate nameLower or something which always holds the username in lowercase for searching purposes.