educative.io

WHERE keyword always ignores case-sensitivity?

Courses
,
#1

I have just read about the WHERE keyword that it performs case-insensitive search by default but my question is does it ignore case-sensitive when we have a column where collation is cs (case-sensitive)

Thanks

Course: https://www.educative.io/collection/5352985413550080/6335716377231360
Lesson: https://www.educative.io/collection/page/5352985413550080/6335716377231360/5835569314660352

1 Like
#2

Hi @ahmed_anwar , Thank you for contacting the Educative team with your query!

By default in SQL, server collation is case insensitive, and the table field is also case insensitive. If the database collation is altered to case sensitive then the selected column must be the exact same case so that only it will work and if we use ‘where’ it will ignore case sensitivity.

Please feel free to reply here if there is still some confusion.

Hope you have an amazing learning experience on Educative!

1 Like