Hi guys
i have a slight problem with some of the chars used in encryption.
When a user tries to create an account in my system, the system encrypts the username/password before putting it into the DB.
When the user tries to log in, the system encrypts the username/password used to log in and tries to find a matching encyption in the DB.
problem is, the
test username (hsimpson) i just used has a ' in the encyption
this means, the SQL created looks like this:
SELECT username FROM tblUserSecurity WHERE username = '������:Y�`�U
'��C�x'
So it' breaking my SQL query and I'm getting an error:
<com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '��C�x'' at line 1>
is there anyway I can stop SQL from using ' in encryption?