Database insert (text)

[Anon]

I have this problem 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)

1. add_doc.php

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

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

2. preview.php

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

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="comments">

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

3. insert_script.php

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

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

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

when I call the recordset with SQL statement

$find=mssql_query
("SELECT comments_insert
FROM temp_approval
Where doc = 'new'
");

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

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

Thanks

[jc94062]

4096 sounds like a SQL limiting number of sorts, check whats being stored in the db, its quite possible only 4096 chars are being stored to be output and the rest if being cut off.

I had a password field with varchar(30) assigned to, but couldn't understand why I was having problems when I changed to md5(), the problem obviously being that whether the pw was correct or not I was checking a 32 bit hashed pw vs a 30 char hash in the db.

[Anon]

OK,

My posting gave a very detailed description of the process in wich I was having problems with. If you know anything about SQL Server you know that (text) datatype holds 2³¹ that is 2,147,483,647 characters. So of course it is not the size of the input to the db because I stated in my original posting that the max db inset would be 32,000 characters. also in the phph.ini file you have what is called ;mssql.textsize=4096

;mssql.textsize default is 4096

So this is the problem

FYI

[jc94062]

You posted so much I just skimmed it, but I still can't see anything saying that the db field is text there, anyway, it was just a suggestion.