How to to verify case sensitive columns in SQL SERVER having Case insensitive Collation.
Use this query
SELECT * FROM LoginData WHERE username ='something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';
OR
SELECT * FROM LoginData WHERE username LIKE 'something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';
14f8ded6-e0cc-4894-9fca-72bad1d995c1|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
SQL
Case insensitive SQL, check username password