Some database providers support case-invariant searching, while others do not. Add a second version of each text field, named Normalized____, which should contain a copy of the raw version of the field that has been converted to upper-case. Normalized fields should be utilized in the following ways:
when searching, the input search string should be converted to uppercase in C# code
the search should be performed against the normalized field instead of the raw field
the normalized field should be the index if the column is indexed
Some database providers support case-invariant searching, while others do not. Add a second version of each text field, named
Normalized____
, which should contain a copy of the raw version of the field that has been converted to upper-case. Normalized fields should be utilized in the following ways: