Why is the like operator case sensitive in data explorer? Which database is being used on the backend? Sql Server's like operator was case insensitive the last time I checked.
What is meta?
- Any Stack Exchange user can ask a question
- The community provides support, votes on ideas, and reports bugs
- Your voice helps shape the way Stack Exchange operates
It depends on the collation of the column, which is normally the database's default collation, unless it was explicitly set. You can change it in a query with the COLLATE clause, as shown in this SEDE query.
I have also provided a query to retrieve the available collations.
Its like @MarkHurd said, it depends on the collation of the database, if its case sensitive, then comparisons like