DBTextLimit
database parameter
Description
Specifies the maximum length of a text field that is returned when
you include the text field in a SQL SELECT statement.
You can set the DBTextLimit 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
ASE and SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
|
1 |
DBTextLimit='value' |
|
Parameter |
Description |
|---|---|
|
value |
The maximum length in bytes of a text field that is When you set DBTextLimit to 0, the server |
Default value
The default value for DBTextLimit is the default specified for the
DBTEXTLIMIT DB-Library or CS_TEXTLIMIT CT-Library connection
property.
Usage
The text field length that DB-Library or CT-Library returns is the
lesser of the DBTextLimit value and the setting for the global variable
TEXTSIZE.
If the setting for TEXTSIZE is less than the value you specify for
DBTextLimit, DB-Library or CT-Library returns the TEXTSIZE value.
Examples
To have DB-Library or CT-Library return a text field that is up to
32,000 bytes long when you include the text field in a SQL SELECT
statement:
-
Database profile
Type 32000 in the Text Limit in SQL box (when using the ASE,
or SYC interface), or Maximum Length of Long VarChar box (when using
the DirectConnect interface) on the Syntax page in the Database
Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="DBTextLimit='32000'"