Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Text Size Limit in MS SQL Server 2000

671 views
Skip to first unread message

M_Desai

unread,
Jul 16, 2003, 3:45:54 AM7/16/03
to
Hi All,

I am using OLE DB to connect to database in SQL Server 2000. everything
works fine.

Only problem is Text size for column is about 340K. Text updated with
correct size (May be, coz I haven?t retrieved full text from database yet)
This was confirmed by following SQL in query analyser.

SELECT max(datalength(form_content)) FROM we_pbForms WHERE qnr = 1

When, I use embedded SQL in Powerbuilder script. it just return 32K text
from that column.

According to OLE DB help, Default DBTextLimit 2GB. Which is automatically
set to @@TEXTSIZE variable in database. I also tried with changing
DBTextLimit = 2097152, that is far greater then 339K

Any tips for this problem???

Regards
MDesai

WS

unread,
Jul 18, 2003, 9:09:19 AM7/18/03
to
PB code:
For embedded sql, what is the return variable datatype used to store the
value?
blob is the recommended datatype to store text of bigger value, or the text
is limited to the datatype declared.
You need to treat the text as a BLOB to get values > 32k limit.

PB dbparm:
To accept bigger text values for MSS interface, you could set
SQLCA.dbParm = "DBTextLimit = '32000'"

SQL server database:
SET TEXTSIZE { number } : resets the @@TEXTSIZE function return value.
The maximum setting for SET TEXTSIZE is 2 gigabytes (GB), specified in
bytes.
The SQL Server ODBC driver and Microsoft OLE DB Provider for SQL Server
automatically set TEXTSIZE to 2147483647 when connecting.


<M_Desai> wrote in message
news:531B796C33F61E75002AA7A885256D65.002AA7E885256D65@webforums...

0 new messages