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.
Controls
-
ASE, SYC, and SYJ SAP
Adaptive Server Enterprise -
DIR Sybase DirectConnect
-
SNC SQL Native Client for Microsoft SQL Server
Syntax
|
1 |
DBTextLimit='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
The maximum length in bytes of a text When you set DBTextLimit to 0, the server returns the maximum length |
Default
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
32000in the Text
Limit in SQL box (when using the
ASE, or SYC, or SYJ 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.DbParameter="DBTextLimit='32000'"