PBMaxBlobSize in the pbodb.ini file was set too low.  once I bumped it up the text was no longer truncated 

No when i select the varbinary(max) into a blob variable and convert it to string the document is displayed as it should

Thanks everyone for your help especially Markus who provided a link with the solution!

Thanks for your suggestion Markus.  when I use your select I still get only part of the richtext string

Hi Tim

We're storing out richtext data in varchar(max) columns in SQL Server. (And access them with SelectBlob and UpdateBlob to circumvent the 64K limit)

If you're converting your varbinary(max) data into varchar(max) in SQL Server, is the result still a valid rtf string? If so, you should be access your data with:

SelectBlob convert(varchar(max), <column> )
into :<blob variable>
from <table>
where <whatever>

Regards,
Markus

Thanks Chris,

The IDE didn't crash this time but when I convert it to string I get ÿþ{

We're switching from Oracle to Sql server

We have richtext in a varbinary(max) field.  I need to get that out of the database and put it in a richtext control so the user can read it

When using oracle we selected the blob into a blob variable then convert it to a string with no issue

Now that we are in sql server it seems the text is being cut off for anything longer than 65535 chars.  At first I thought it was the string conversion in PowerBuilder but have since learned that it's a limitation of SQL server and the only way to get all the text is to cast it as xml.  I've confirmed this in Management Studio as well.

Casting it to xml causes the IDE to crash.  

Hi Tim;

  Please try using a SelectBlob DML command instead.

HTH

Regards ... Chris

Yes I have also tried that and it still crashes. 

Hi.

I wonder what datatype is returned by ODBC Driver 17. It may not a varchar... Have you tried to get the value using select blob?

Andreas.