text dataype data retrieval 1

[lothadio]

I am having difficulty retrieving more than 4096 characters from the (text) datatype field.

I have been advised to retrieve this data block by block? however the Microsoft Documentation is not very clear unless you are a T-SQL expert(I am not)

My data field(comments_insert)is around(32,000)characters max, how do I simply extract this data and output it to html via SQL, Do I need some special T-SQL query to do this?


I will explain the whole process and I hope some one can help

******************The application*************




******************SPECS*******************
MSSQL SERVER 2000 enterprise
PHP4
Netscape Enterprise Server 3.6

table temp_approval
doc (char)
comments_insert (text) //this datafield will not exceed 32,000 characters


1. add_doc.php

<form &quot;multipart\form-data&quot; method=&quot;post&quot; action=&quot;preview.php>
<textarea name=&quot;comments&quot;></textarea>
<input type=&quot;image&quot; name=&quot;submit&quot; src=&quot;images/nextorg1.gif&quot;>

Description
this is where the user enters data to be inserted into the database



2. preview.php

<form enctype=&quot;multipart/form-data&quot; action=&quot;insert_script.php&quot; method=&quot;post&quot;>
<input type=hidden name=&quot;comments_insert&quot; value=&quot;<?echo urlencode($comments);?>&quot;>
<?
echo (&quot;$comments&quot;
?>
<input type=&quot;image&quot; name=&quot;insert_data&quot; src=&quot;images/submtbtngryb.gif&quot;>

Description
this is where the user previews their data before they start the insert process

the data is passed from 1.preview.php via <textarea name=&quot;comments&quot;>

This is where $comments_insert is created via
<input type=hidden name=&quot;comments_insert&quot; value=&quot;<?echo urlencode($comments);?>&quot;>



3. insert_script.php

$insert_temp_approval=mssql_query
(&quot;INSERT
INTO temp_approval (doc,comments_insert)
VALUES ('new','$comments_insert')
&quot;


The variable for $comments_insert was created on the previous page via
<input type=hidden name=&quot;comments_insert&quot; value=&quot;<?echo urlencode($comments);?>&quot;>



********************The Problem*****************

when I call the recordset with SQL statement

$find=mssql_query
(&quot;SELECT comments_insert
FROM temp_approval
Where doc = 'new'
&quot;

while($row1= mssql_fetch_array($find))
{
$result= $row1[&quot;comments_insert&quot;];
}
echo $result;



the maximun characters that are returned are 4096. So basically what is the problem with retrieving more than 4096 characters from the database? Is this MSSQL Server issue, or is this PHP4 issue or maybe something else?

Do I actualy need to retrieve this data block by block? Or do I need to modify my sql statement with some special T-SQL?

Some one please help, and dont tell me to read the MS BOOKS online, I am not a DB developer and it does not help me?

Thanks

 

[tlbroadbent]

I found the following information in a PHP Newsgroup. It appears that if you set the PHP directive as indicated PHP will handle the SQL TEXT.

There are php.ini (PHP4) directives for MSSQL that set text size. Uncomment the lines and change the 4096 to 32000 or whatever you need.

; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096

Being unfamiliar with PHP, it is difficult to know if the PHP fix will be the answer to your problem. If not, you can try this T-SQL statement to see if it will help.

SET TEXTSIZE 32000

This specifies that the size of text and ntext data returned with a SELECT statement will be 32000 bytes rather than the default of 4KB. Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes