Live Forms In-House on SQL Server - deprecated data type
Hi, I'm currently evaluating a trial copy of Live Forms In-House for my organisation. I've switched the standard Hyper SQL database over to using SQL Server 2008 R2.
I see that you are using an "image" SQL data type to store XML on the documentsubmission table of the frevvo database. Since this is a deprecated datatype, do you have any plans to change this in a future version? I need to be sure that the product is future-proofed for SQL Server, and will work with whatever version follows SQL Server 2012.
To work around it, I have modified the datatype to varbinary(max) and tested to find it working. I have also tried the datatype "XML" instead of "image" and found it working correctly.
Do you see any issues in using these datatypes (XML or varbinay(max)) instead of image?
-
I can't think of any issues but on the other hand the reality is that we have not run QA with that modification and therefore there are no guarantees. I guess you seem to be on the right track for the short term by making the modification and thoroughly testing your solution.
For the long run: We have an internal ticket to address that issue and the modification will be released in the next frevvo version. Rest assured that we will take care of it.
0
Please sign in to leave a comment.
Comments
1 comment