text > 65536 chars data type?

text > 65536 chars data type?

Post by Greg Russe » Fri, 04 Sep 2009 08:12:57

We have a table with few records which have a field of type "text".
Apparently this data type is limited to 65536 characters.

Would someone please suggest a different data type that will allow us to
include all necessary text that is generated for each record's field,
regardless of number of characters needed? The number of characters for the
field might vary between a few hundred and a few hundred thousand.

text > 65536 chars data type?

Post by Captain Pa » Fri, 04 Sep 2009 08:23:36

I know of someone who can tell you all you need to know about this. I
will introduce you.

Meet the manual: