Text exported from Sql server 7 truncated
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 as entered.
However when I export using Dts to Csv, or access the SQL db using Access 2003 the text, plain or in rtf tagged form, truncated.
I've seen articles referring to a 255 character limit without specific syntax when storing text in SQL server older versions, and wonder if same could apply to export?
I've seen another article that refers to 1024 setting in odbc bindings, but this seems inconsistent with Dts.
I've seen another article which refers to special characters causing text processing issues which would seem relevant with the rtf tags being present.
It is possible to copy and paste the text using Windows clipboard.. But there are too many records to be practical.
Any guidance or suggestions gratefully received...