SQL Server 7 Text Truncation on Export
Posted on 2014-10-31
I'm migrating a legacy sql 7/VB app... Several Text fields defined length 16, hold plain and rtf tagged text variously.
It appears that the rich text field in the VB app successfully display the text, plain or rtf, at its full length (>1000 chars) as entered, and can be copied manually via the Windows clipboard.
However when I export using Dts, or access the SQL db using Access 2003 the stored text is consistently truncated to <255 characters - I've seen articles referring to a 255 character limit requiring specific VBA syntax to workaround when storing text in SQL server older versions, and if as it appears the same issue applies to DTS export, wonder if anyone knows of a workaround on the backend ? or conversion tool compatible with SQL Server 7 ? (plenty for newer versions but cant find one that connects to SS7).
I've seen another article which refers to special characters causing text processing issues which could be relevant with the rtf tags being present. But seems less likely.
Any guidance or suggestions gratefully received...