Has anyone experienced field truncation on Export?
I have a text table field that is trunctated when exported to MS SQL database. Field type is nvarchar(50). No error message is shown. Table fields look ok on verification but when exported not all field content is exported. One thing i've noticed is that all table fields are stored with the same length, the first row item's length. I've performed some testing and noticed that changing the first row item so that is the one that contains more characters, the export is done well.
This field is filled up by a Database Check rule of another field.
Should i be reporting this to support?
Hope this helps someone.
I have a text table field that is trunctated when exported to MS SQL database. Field type is nvarchar(50). No error message is shown. Table fields look ok on verification but when exported not all field content is exported. One thing i've noticed is that all table fields are stored with the same length, the first row item's length. I've performed some testing and noticed that changing the first row item so that is the one that contains more characters, the export is done well.
This field is filled up by a Database Check rule of another field.
Should i be reporting this to support?
Hope this helps someone.
Comments
2 comments
Thank you for your researches!
I will forward your investigation to our support team.
Please sign in to leave a comment.