How to declare field case insenstive?

I was writing unit test for utility class which uses aurelius and used sqlite memory database during unit test.
test failed while retrieving strings with different case.
I couldn't find attribute to declare field as case insensitive,
is there one?

Unfortunately that is up to the database. SQLite comparison is case sensitive by default.
One thing you can try to do is manually set a field in the table as case insensitive using NOCASE:

ok, thanks.
We will try.

1 Like