Hello everyone
I am taking username and password from user checking it against db now while checking, it is not case sensitive ..
For example
user enters
user Name : abc
password : a
now the query is "select usrid from userMaster where unm='abc' and password='a' "
this query is giving me output whenever user enters 'abc' as well as 'Abc' for both
i.e. it is not case sensitive what should I do for this
if you are talking of oracle user name and password , that is not case sensitive.
No its SQLServerOriginally Posted by debasisdas
There are many ways to do that
To use the case sensitive query in Sql u have to use its collation property along with query in format.
Collate SQL_Latin1_General_CP1_CS_AS
SELECT * FROM CaseSensitiveTest
WHERE Value1 LIKE '%Test%' Collate SQL_Latin1_General_CP1_CS_AS
Hope this would help u.
---V V---
Vikas Vaidya
Last edited by debasisdas; 04-16-2009 at 03:36 AM. Reason: link removed.
Posting Permissions
Reply With Quote