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.
