As per requirement, it should be encrypted and can not be changed to any other type.
Yaojian wrote: > > why not define the ANSWERTEXT as Varchar or NVarchar ? > > On Tue, Apr 7, 2009 at 9:56 PM, Jain Mohit <[email protected]> wrote: > >> >> Hi, >> >> I am using ASP.Net 2.0 framework/C# & SQL server 2000 and using iBatis >> for >> database interactions. In the code snippet below (bold text), ANSWERTEXT >> field is of type Varbinary. While inserting data to this field, I used >> convert function. >> >> INSERT INTO SecretAnswer(ParticipantId, QuestionId, QuestionCode, >> ANSWERTEXT) >> >> SELECT ParticipantId, #questionId#, #QuestionCode#, >> CONVERT(varbinary(255),#Answer#) >> >> From table.....(some join conditions) >> >> >> Case 1. In case of 'Answer' being a normal alpha numeric string >> "test123", >> it converts the string to varbinary properly and while validating, I am >> able >> to validate properly. >> select convert(varchar(100), answer) from table >> >> Result: >> test123 >> >> Case 2. In case of 'Answer' having any special character (e.g. >> apostrophe), >> it does the same. However, when I execute the following in query >> analyzer, >> the result is not equal to the original string. >> >> E.g. Answer = "test'123" >> >> Inserted this using above insert statement. Executed following: select >> convert(varchar(100), answer) from table >> >> The result comes only single char: >> t >> >> While select convert(nvarchar(100), answer) from table, returns >> "test'123", >> which is a problem. >> >> Can someone look into this and respond accordingly? >> Regards, >> >> Mohit Jain >> >> >> -- >> View this message in context: >> http://www.nabble.com/Prob%3A-using-varnibary-in-iBatis-asp.net-tp22929580p22929580.html >> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Prob%3A-using-varnibary-in-iBatis-asp.net-tp22929580p22930420.html Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
