hello, i'm hoping that someone can help with this little problem. i have an third party app with a gui interface and sql back end. the app has the capablities of entering in users through the front end but i have created a sql script that reads an alternative table of users and inserts them into the user table of the third party app (for batch entry and profile creation).
my problem lies in the password column, its a binary data type. but when i convert my text password to binary text it does not match up.
results for password (1234567)
3rd party app (password is verified and works)
0x9F9E9992949D959E129491A9A9A3A9E6E90FE9C2
sql conversion
0x3132333435363720202020202020202020202020
--sql script to convert text to binary
declare @uPassword char(20), @binPassword as binary(20)
set @uPassword = '1234567'
set @binPassword = cast(@uPassword as binary(20))
print @binPassword
heres the script that i am using to convert the text to binary...am i doing something wrong here? i put 20 because thats the length of the column in the 3rd party db.
any help would be greatly appreciated...i have little exprience in binary data.
thanks,
t
my problem lies in the password column, its a binary data type. but when i convert my text password to binary text it does not match up.
results for password (1234567)
3rd party app (password is verified and works)
0x9F9E9992949D959E129491A9A9A3A9E6E90FE9C2
sql conversion
0x3132333435363720202020202020202020202020
--sql script to convert text to binary
declare @uPassword char(20), @binPassword as binary(20)
set @uPassword = '1234567'
set @binPassword = cast(@uPassword as binary(20))
print @binPassword
heres the script that i am using to convert the text to binary...am i doing something wrong here? i put 20 because thats the length of the column in the 3rd party db.
any help would be greatly appreciated...i have little exprience in binary data.
thanks,
t