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.
Applies to
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
|
1 |
PBMaxTextSize='value' |
|
Parameter |
Description |
|---|---|
|
value |
The maximum length in bytes of text or large value |
Default value
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:
1SQLCA.DBParm="PBMaxTextSize='48000'