Case Sensitivity in SQLServer
In SQLServer I faced one problem with Case sensitivity
SQLServer didn't differentiate this
ADMINISTRATIVE ASSISTANT
Administrative Assistant
Some time SQLServer wont recognize this issue.Because of tha collations.When we create database we case define the
Case sensitivity
That too in SSRS.It was quite difficult.To sort out this issue
only way you can set this collate in SQLServer and convert the required field in Binary(in web lot of codes are available)
To know the full details Run the below query in SQLServer
SELECT *
FROM fn_helpcollations()
We can use this funciton to get all available formats for collate
This one basically used for Case sensitivity
this is the default 'CI_AI_KS collate Latin1_General_CI_AI_KS'
Want a Easy one in SQLServer
select cast('Gowtham' as varbinary)
select cast('gowtham' as varbinary)
select cast('GOWTHAM' as varbinary)
Simple way to differentiate.. Happy Coding.
0 Response to "Case Sensitivity in SQLServer"
Post a Comment