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:[EMAIL PROTECTED]]
> Sent: Jueves, 05 de Julio de 2001 09:37 a.m.
> To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows 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]
