JavaScriptCode answertype takes first 8000 chars only

[ia5634]

1. ISSUE/ BUG/ ERROR

a. Expected Behaviour

Js based answertype should save with unlimited chars... Script must not be cut...

b. Actual Behaviour

Only first 8000 chars loaded on page.

c. Steps to Reproduce Behaviour

1. Change varchar(8000) to varchar(MAX) in vts_tbAnswerType
2. JavascriptCode varchar(8000), to JavascriptCode varchar(MAX) in StoredProcedures vts_spAnswerTypeAddNew
3. JavascriptCode varchar(8000), to JavascriptCode varchar(MAX) in StoredProcedures vts_spAnswerTypeUpdate

d. Possible Cause and/or Solution

I did steps above but nothing is changed. I couln't find whats wrong.
If I set varchar(100), its ok. Saves first 100.
If I set varchar(1000), its ok. Saves first 1000.
If I set varchar(MAX), its takes only first 8000 chars to save in db.
If I manually edit vts_tbAnswerType (paste my long script has more than 8000 chars), it ok. But If I want to add new or update an existing type, it takes the firsy 8000 again.

I think I found the point... It is in Nsurvey_SQLServerDAL.dll AnswerType action. It must be "-1" as size. Found but couldn't build the project. Shows many errors.

e. Technical Specifications

• Version of Survey Project: 2.5 beta
• Browser Type & Version: Chrome and Firefox
• Operating System: Win10 x64

f. Context (Environment)

MAX chars for js provides more neat pages and more usefull SP.

[ia5634]

An update;

• Finally managed to build solution.
• My build is working just like I want.
• Now I have JavascriptCode column with varchar(MAX) without any problem.

I can share the dll if you want.