Symptoms
Case-sensitive search in picker control
Diagnoses
Is there any way to turn off the case sensitivity in a picker control? Either by modifying a web.config file or even within a SQL query for the data source of that specific picker control?
Resolution
Customer was using a SQL server service instance where Use Native Execution = true, and On different SQL server = true as such a linked server is created on the K2 SQL server that connects to a different SQL server where the referenced database resides. Customer resolved the case sensitivity issue by changing the "Use Remote Collation" property of the linked server from "True" to "False".
