Hi, I have an on premise deployed app with a MS SQL DB. I noticed that the search functionality on data grids is case sensitive. It is not case sensitive when I use PostgreSQL on my dev laptop. Is this normal? This post states that MS SQL is case insensitive when it comes to Xpath retrieves...
SQL Server is configurable to be case sensitive based on a property called collation. Check out the top answer here.