Security

Re: check case sensitive while login

bijujoseph — Wed, 22 Aug 2007 08:54:10 GMT

hi prasanth,

Thank you very much

Re: check case sensitive while login

prasanthr — Thu, 09 Aug 2007 05:47:54 GMT

Hi,

You have to use "CAST" Function in SQL statement, as follows,

SELECT *
FROM logintable
WHERE CAST(LoginName AS Varbinary(255))= CAST('test' AS Varbinary(255)) AND [Password] = @Password

Here the password is md5 encrypted....

hope this will help you..

regards

prasanth

Re: check case sensitive while login

naturehermit — Wed, 01 Aug 2007 08:56:17 GMT

How are checking for username, password in your webapplication? Are you using membership api?

Re: check case sensitive while login

XiaoYong Dai – MSFT — Wed, 01 Aug 2007 08:44:04 GMT

The reason why the username is non-case-senitive is that in the stored procedure [dbo].[aspnet_Membership_CreateUser], UserName is converted into all lowercase before inserting into the DB

To change this just goto the sp and change the

LOWER(@UserName) = LoweredUserName

@UserName = UserName

make the aspnet_Users table stores the original UserName.

Hope it helps.

Re: check case sensitive while login

bijujoseph — Mon, 30 Jul 2007 11:19:20 GMT

plz don't confuse when i said 'both MS SQL Server 2000 and 2005'

for some application, i use MS SQL Server 2000

and for some other application, i use MS SQL Server 2005

check case sensitive while login

bijujoseph — Mon, 30 Jul 2007 09:31:00 GMT

hi all,

i am using asp.net 2.0, and both MS SQL 2000 and 2005

i have a table -login like below

UID UserName Password

1 test test

i want to login to a web application using this username and password

but, what i want is, it should be case sensitive

a user shall be able to enter in to the application only if he enters username -test and password -test

he shall not enter for other combinations like TesT, Test, tesT etc...

how shall i do that?

thanks in advance