docs icon indicating copy to clipboard operation
docs copied to clipboard

Improve case sensitivity section for SQLite provider

Open m-abdelwahab opened this issue 4 years ago • 1 comments

image

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

m-abdelwahab avatar Jun 09 '21 10:06 m-abdelwahab

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.

CanRau avatar Jul 08 '22 07:07 CanRau