Share on FacebookThere is some what of a problem when inserting huge amounts of text in a textfield. I've working on a site right now where the user will edit the whole contet of the page itself with the help of FCKEditor.
I started with an Access Database and outgrew that one in 20minutes, exported the database to a SQL 2005 database. The PM value in Access will be ntext in SQL, this is wrong and it should be just text. My next issue is that the maxtextsize in php is to small, so we need to change that in the php.ini
mssql.textlimit = 65536,
mssql.textsize = 65536;
Then you also need to change the textsize of the queries insert this code before the queries or if you work with classes you could add this code to the constructor.
mssql_query ( 'SET TEXTSIZE 65536' , $myConn ); // myConn is the connection identifier for the connection.
ini_set ( 'mssql.textlimit' , '65536' ); // Not needed but I set them anyway
ini_set ( 'mssql.textsize' , '65536' ); // Not needed but i set them anyway
This solved this for me, i'm not sure how this works with MySQL, if you do, please leave a comment.
9a738a29-5a0a-4f1e-990b-9febf679ba7e|0|.0