php - Password Case Sensitivity using BINARY from MYSQL to SQLSRV -

php - Password Case Sensitivity using BINARY from MYSQL to SQLSRV -

i wonder if can help me here.

basically, i'm trying create login script case-sensitive when inputting password.

i made work in php mysql using below code, using binary:

$qry="select * studentrecords username='$login' , password=**binary**'".($_post['password'])."'";

i've tried using in php sqlsrv, not working.

anyone can tell me alternative way or how create work in php sqlsrv?

thanks in advance, i'll appreciate alot.

your sql server database's default search alternative case insensitive. can alter setting query below using collate:

$qry="select * studentrecords username='$login' , password collate latin1_general_cs_as ='".($_post['password'])."'";

you should @ usage of parameterized queries avoiding sql injections. microsoft's official sqlsrv driver api reference has examples.

much more info collate

php mysql case-sensitive sqlsrv