modified survey response column to nvarchar(max) to save string longer than 4000 characters.
columnName="user_agent"
newDataType="${user-agent.type}"/>
</changeSet>
+
+
+ <!-- 4211 increased length of string_response column from 4000 to max -->
+ <changeSet id="20190722-4211"
+ author="muzammilali"
+ dbms="mssql">
+ <comment>4211: Change string response column to nvarchar(max) to allow string larger than 4000 characters</comment>
+
+ <modifyDataType columnName="string_response"
+ newDataType="nvarchar(max)"
+ tableName="survey_question_response"/>
+ </changeSet>
</databaseChangeLog>
