note 41163 added to function.mssql-connect

Little idea about 255 characters limitation. :) In tables I'm using column type "varchar" or "nvarchar" instead "text". And also I use for example varchar(8000). And there is "a bug". :) PHP will read this column only as varchar(255). So how to read more then 255 chars from varchar(8000)? It is very easy, use CAST to convert varchar type to text type. select CAST(Comment as TEXT) from Job PHP will read it. Check php.ini section [MSSQL] and set maximum text length. Check parameters mssql.textlimit = 4096 mssql.textsize = 4096 Maximum length is 2147483647 Bye ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+41163 Delete -- http://master.php.net/manage/user-notes.php?action=delete+41163&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+41163&report=yes Search -- http://master.php.net/manage/user-notes.php