Re: Working with the text datatype in Mysql

[Santino]

The problem could be in the HTML page.

I suppose You use a form to submit data.

If You want to pass more than about 1K data You must use POSTs and not GETs.
The Get option has a limit in the URL len so You can not successful 
pass more than 1K bytes (browser/platform specific limit). The url in 
this case is "http...." plus parameters name values and separator (?, 
&  and -=".

So if You use GET (or You use default mode) You have to change it to 
POST in the form:
<form name=...  method=POST>

Now in the php page You can put an echo of your form variables:
echo "-$Text-";   // If You have Globals on in php.ini file
echo "-".$_Request[ "Text"]."-"; // in php >= 4
Then after the insert You can add:
 if( mysql_errno() != 0)
     echo mysql_errno() . ": " . mysql_error() . "<BR>\n";
to see if there was an error.
Santino

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]