Storing characters like % and \ in MySQL fields?

I have a function to generate an 11 character salt. This salt can include characters like % which I know is wildcard in SQL and \ which is used for escaping things. Some users are complaining about not being able to log in. Could these characters in their password salt be the problem?

Answers


Unequivocally yes. specifically the backslash if it is not done correctly. If you are doing this salting/hashing in mysql only that is a bad idea, i would suggest you perform it in a server side language before storage, and if you are already, you could always sha1 or md5 your hashed result before storage.


Need Your Help

Like button in iOS app with Facebook Single-Sign-On

iphone facebook ios facebook-like

Is there any way to use the FB Single-Sign-On sign in flow in combination with the like button in a UIWebView?

Ways to convert String to char in java without built-in libs

java string char

is there a way to covert a string to an array of char without using any library functions (ex:- split,tocharArray etc)in java