How to declare field case insenstive?

BIZ TMS Aurelius
1

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?

2

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:

3

ok, thanks.
We will try.

1 Like