collate method
Apply this index's collation rules to a key value at column position
pos. Currently only 'NOCASE' transforms strings (lowercased).
Implementation
Object? collate(int pos, Object? value) {
if (value is String &&
pos < collations.length &&
collations[pos].toUpperCase() == 'NOCASE') {
return value.toLowerCase();
}
return value;
}