RE: Witango-Talk: Case Sensitivity

[Willochell, Mike]

Dave,   Thanks for the suggestion.   I was actually looking at hash encryption, but my concern was how unique it would really be. In other words, is there even the remotest of possibility that the hash of a wrongly entered password could equal the hash of the correct password? What raised this concern is that we encountered where hash functionality on our databases were not always generating unique strings for unique numbers. We were attempting to generate unique identifiers from unique social security numbers, but we had several cases where two very different numbers resulted in the same hash value. Out of just over 10,000 records, we have 6 where the hash values are not unique even though the source strings are.   Do you have any thoughts on this.   Thanks.   Mike   From: David Shelley [mailto:[EMAIL PROTECTED] Sent: Monday, June 05, 2006 10:03 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Case Sensitivity   Mike,   One way to do it would be to do a hash encryption on the values then compare them in an IF tag. The encrypted value of ABC will be different than the encrypted value of AbC.   I haven’t done it before, so there may be other ways too.   Dave   -----Original Message----- From: Willochell, Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, June 05, 2006 9:46 AM To: witango-talk@witango.com Subject: Witango-Talk: Case Sensitivity   Hello,   Would anyone know of a simple way in Tango to make a case sensitive comparison of alpha-numeric strings?   What I really need to do is check passwords that get submitted though forms against values stored in a database table using a Search or Direct DBMS action. I know I can enable case sensitivity on the database, but this is global and would affect too many other applications, so this is not a viable option. For security, I also want to avoid using any client side scripting.   Any suggestions would be appreciated.   Thanks.   Mike   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf