[PHP] Large Text Fields from MS SQL DB Truncated

2001-07-02 Thread James Crowley

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 - [EMAIL PROTECTED]
ICQ#  - 60612011
Fax   - +44(0)8707052859
==


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Large Text Fields from MS SQL DB Truncated

2001-07-02 Thread Frank M. Kromann

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 - [EMAIL PROTECTED]
 ICQ#  - 60612011
 Fax   - +44(0)8707052859
 ==
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]
 
 
 




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]