How can I make my query case-sensitive?

Asked Jan 30 '18 at 21:49

Active Jan 31 '18 at 08:32

Viewed 51 times

I want to make this query case sensitive.

                Managers.AddParameters("@Manager_Username", 
                TXTUsername.Text.ToString)
                Managers.AddParameters("@Manager_Password", 
                TXTPassword.Text.ToString)
                Managers.MakeQuery("SELECT Manager_Username, 
                Manager_Password, 
                Manager_ID, Manager_Name FROM SaleManager WHERE 
                Manager_Username = @Manager_Username 
                AND Manager_Password = @Manager_Password")

At the moment it doesn't matter if the data i enter is uppercase or lowercase. I am using data adapters

edited Jan 31 '18 at 08:32

asked Jan 30 '18 at 21:49

the real swifty

See https://stackoverflow.com/a/1831120/7531598 – Lee Mac Jan 30 '18 at 21:57
3

Possible duplicate of [How to do a case sensitive search in WHERE clause (I'm using SQL Server)?](https://stackoverflow.com/questions/1831105/how-to-do-a-case-sensitive-search-in-where-clause-im-using-sql-server) – Lee Mac Jan 30 '18 at 21:58
2

...or `case ensative` as the case may be. Passwords should never be stored as plain text. – Ňɏssa Pøngjǣrdenlarp Jan 30 '18 at 22:15
1

@HoneyBadger, oops, I misread. Force a case sensitive collation is my tip then! – jarlh Jan 31 '18 at 07:38
@Plutonix What would be a better way to store my passwords store my passwords. – the real swifty Jan 31 '18 at 08:30
1

Create a [hash](https://stackoverflow.com/a/10402129/251311) of the password and store that. – Magnus Jan 31 '18 at 08:59
Note that hashing the password string should also make the passwords case sensitive. – Dylan Brams Jan 31 '18 at 13:11

How can I make my query case-sensitive?

0 Answers0