note 98779 added to function.mssql-query

I have a mssql database with an ntext data type and was having problems as the cast solution data was still being truncated by php, i combined a couple of methods from here and elsewhere on the internet. If you have are retrieving vast amounts of text from a SQL Server database into your website. use SQl statements using cast e.g. SELECT CAST(details as TEXT) from table and in the php.ini file change these values in the [mssql] section, from 4096 to whatever size and limit, remember to remove the ; from the front of the ammended line ; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = 2147483647 ; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = 2147483647 ---- Server IP: 69.147.83.197 Probable Submitter: 20.138.1.245 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- https://master.php.net/note/edit/98779 Del: integrated -- https://master.php.net/note/delete/98779/integrated Del: useless -- https://master.php.net/note/delete/98779/useless Del: bad code -- https://master.php.net/note/delete/98779/bad+code Del: spam -- https://master.php.net/note/delete/98779/spam Del: non-english -- https://master.php.net/note/delete/98779/non-english Del: in docs -- https://master.php.net/note/delete/98779/in+docs Del: other reasons-- https://master.php.net/note/delete/98779 Reject -- https://master.php.net/note/reject/98779 Search -- https://master.php.net/manage/user-notes.php