PBMaxTextSize – PB Docs 126

PBMaxTextSize database parameter

Description

Specifies the maximum length of text or large value datatypes
returned when you include them in a DataWindow.

You can set the PBMaxTextSize parameter if you want to include
a long text string in a DataWindow object without treating the text as
a binary large object (blob) datatype.

Controls

  • SNC SQL Native Client for Microsoft SQL Server

Syntax

Parameter

Description

value

The maximum length in bytes of text or
large value datatypes returned when you include them in a DataWindow.
The DataWindow can be created by a procedure. The range of valid values
is from 10,000 bytes to 1,000,000 bytes.

Default

PBMaxTextSize=32767

Usage

The SQL Native Client
OLE DB Provider for SQL Server
automatically sets the SQL Server
TEXTSIZE property to 2147483647 when connecting. The size of data
fetched depends on the PBMaxTextSize parameter. If a result set includes
a large value type, the blocking factor will be set to 1.

Examples

To have SQLServer return text or large datatypes
that are up to 48,000 bytes long when you include them in a SQL SELECT statement:

  • Database profile

    Type 48000 in the Maximum
    String Size in DataWindow box
    on the Transaction page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x