Re: Large Text Fields from MS SQL DB Truncated
| From: | Frank M. Kromann | Date: | Mon, 02 Jul 2001 16:43:05 +0000 |
| Subject: | Re: Large Text Fields from MS SQL DB Truncated | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-55865@lists.php.net to get a copy of this message | ||
Have a look at these two settings in your php.ini
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
- Frank
> Hi,
> I've hit a little problem... When retreiving large TEXT data (equivilant to
> MySQL's MEDIUMTEXT) from a MS SQL database using PHP, the data becomes
> truncated after 4,095 bytes. I have tried connecting both with ODBC, and the
> MsSQL php functions, but to no avail. It works fine in ASP ;-) Any
> suggestions?
>
> Thanks very much,
>
> - James
>
> Editor, VB Web
> ==================
> Web - http://www.vbweb.co.uk
> Email - james@vbweb.co.uk
> ICQ# - 60612011
> Fax - +44(0)8707052859
> ==================
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>