any database field can show only 32K Characters only.
I think you'll need to split the field, Break the field into 32k strings To display the entire field, create a text field, and drag the two fields that hold the two parts into it. (I haven't tried this, but can't think of a good reason why it wouldn't work...)
I knew concatenation wasn't gonna work due to Crystal's string size limitation. I didn't recall the exact number, but it looks like it's 32k...
Joined: 23 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 9
Posted: 17 Jun 2013 at 11:53pm
Thanks Praveen.
Unfortunately if you split the RTF field, the second half does not recognise that it is RTF (due to the fact that that information is held at the beginning of the text).
Joined: 23 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 9
Posted: 18 Jun 2013 at 4:49am
...on further investigation, if I change the Text Interpretation from 'RTF Text' to 'none' it will display the entire contents of the field but, of course, with all the rich text formatting, e.g.
{\rtf1\ansi\ansicpg1252\deff0\deftab850{\fonttbl{\f0\fnil\fcharset0
Arial;}{\f1\fswiss\fprq2\fcharset0 Arial;}{\f2\froman\fprq2\fcharset0 Times New
Roman;}}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
