sql server - sql strictly equals, is there something? -
Possible duplicates:
Basically I need to check something like this
choose * from those users where name = @name, pass = @pass
The problem is that the string in the 'PASS' = 'PASS'
SQL (MS SQL-Server) is somewhat more stringent to compare
It is under your collation, which is It seems that the case is insensitive. For example, the standard code is Latin 1_General_CI_AS
, where ci
means the case is insensitive. You can force a different fusion for a different comparison: Select
Incidentally, you should not store passwords in your database - you should greet them and make them.
php स्क्रिप्ट प्रोग्रामिंग उदाहरण
ReplyDeleteआयात अनुरोध चर चर उदाहरण कोड