Skip to Content
avatar image
Former Member

DBTextLimit doesn't seem to be handled correctly in Sybase 15.7 on Linux


I have an issue with retrieving long text fields from Sybase 15.7 sp136 running on Linux. Exactly the same client app works fine with Sybase 15.5 on AIX and Sybase 16.0 on Windows Server 2012. Connection parameters and drivers are identical too (Open Client 12.5, SYC Sybase System 10/11).

I have DBTextLimit set to '600000' in the connection params. I confirmed the parameter takes effect, if it's set to something small (I can see the text being truncated). However, when it's set to a large number, like 600000, the text is also truncated.

The relevant part of the client powerbuilder code can be found below (see the comment in captials).

Essentially len(string(lds_reportDetails.Object.ht_report_format_text[1]) does not show the actual length of the text field.

My question is, is there any connection parameter, OS parameter or anything else, which could lead to this truncation? Is there any lilmit on DBTextLimit values in that particular version of Sybase on that OS? We're literally running out of ideas.

retRes = lds_reportModes.Retrieve(lds_reportDetails.Object.ht_report_reportid[1])

if retRes < 0 then

sError = "Retrieve Error while getting report modes" + string(myTrans.SQLDBCode) + ": " + myTrans.SQLErrText

this.logmessage(2, "CreateReport", sError) resetReport()

return false


this.logmessage(1, "CreateReport", "retrieved " + string(retRes) + " report modes")

end if

BLOB bformat

int rep_id

if len(string(lds_reportDetails.Object.ht_report_format_text[1])) > 32000 then


this.logmessage(1, "CreateReport", "Format string length: " + string(len(string(lds_reportDetails.Object.ht_report_format_text[1]))) )

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 13, 2016 at 05:15 PM

    I wonder if it could be caused by textsize being 32K. Would it take precedence over DBTextLimit?

    It is 32K in Sybase 16.0 though and it doesn't seem to take precedence.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 16, 2016 at 04:33 PM

    Hi Luke;

    Try using the "ASE" instead of SYC and set your release number for 15.5 & higher in your DBParm (

    ie: SQLCA.DBParm = "Release='15.5'" ) and see if that makes a difference.

    Regards ... Chris

    Add comment
    10|10000 characters needed characters exceeded