note 98779 deleted from function.mssql-query by cmb

Note Submitter: ianknapton at hotmail dot com ---- 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