May 13, 2005 at 4:39 pm
I have a SQL server 2000 sp3 machine I want to create a table with an Identifier column and a column of text inserted by a small web app. I have tried several methods to put the text in to the column, copy and paste in EM, writetext statement in QA etc. All seem to truncate the text to around 4900 characters.
Can anyone shed some light on how I capture a clob of text in a web page and pass it to a stored proc that writes it to a text field in SQL so that I can retrieve and display the text.
Thanks in advance for any advice you can share,
Glen
May 13, 2005 at 10:16 pm
Is your text column of text datatype ?! Here's some info from BOL that may help:
The current TEXTSIZE setting is reported by the @@TEXTSIZE function and is changed with the SET TEXTSIZE statement:
SET TEXTSIZE 64512
The default setting for TEXTSIZE is 4096 (4 KB). This statement resets TEXTSIZE to its default value:
SET TEXTSIZE 0
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply