Re: RE: [PHP-WIN] PHP - MSSQL - IIS Size Question

Migrating is not the only solution ! MSSQL uses a default truncation size of text fields. This size can be changed with parameters in php.ini. The maximum size of a text fiels in MSSQL is 2GB. If you are storeing a 2 GB Text field in the database and try to view it on a web page, the user is most likely gone before the page is rendered. With a full T1 line it would take 4-5 min to download the file. Binary data, can also be up to 2 GB in size so be carefull. I did make some changes to the way binary data are handled between 4.0.5 and 4.0.6. If you are using an older version of php, please update to the latest version. - Frank > Joshua: it appears to be a bug in MSSQL Server I've had the same problem > with text fields larger than 20 pages, I don't know how much this will help > you, but I migrated my entire database to MySQL and now it works fine it can > read text fields as large as 120 pages no problem, also I noticed that MSSQL > tends to truncate the text fields so that not all of the text you entered > gets inserted into your table. > > Try migrating to MySQL I'll bet that it will make your DB and App work fine. > > Iván. > > -----Original Message----- > From: Joshua Butcher [mailto:joshua@jcannonb.dynip.com] > Sent: Jueves, 05 de Julio de 2001 09:37 a.m. > To: php-windows@lists.php.net > Subject: [PHP-WIN] PHP - MSSQL - IIS Size Question > > > I am preparing a report for a database at my company that will be shown on > the web. It has several nested tables and such in it. One of the fields to > show is a blob field. > > If the blob field is too long, IIS will hang, and not be able to render the > table. If the blob field is less than 2K it is fine. Sometimes it is > bigger. > > If I remove the blob field from showing it always works fine, on every > record. If I put the blob field in, it will hang on certain records but not > all. > > How can I increase IIS's or PHP's buffer size so that it will render the > entire page correctly everytime? > > Joshua > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >