RE: [PHP-WIN] SQL Server 7 help needed!!!
| From: | Paco Ortiz | Date: | Wed, 03 Jan 2001 20:10:51 +0000 |
| Subject: | RE: [PHP-WIN] SQL Server 7 help needed!!! | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-4774@lists.php.net to get a copy of this message | ||
Hi:
I reply to myself:
> I'll take a look to the source code of php_mssql.dll, perhaps there is a limit >when
> allocating the buffers for the resultset.
It seems php_mssql.dll uses a MSSQL API called "dbdatlen". This API is not suitable for
text or image fields. In fact, it returns a false text size of 8k (or 4k, depending on the client
libraries and SQL server version you're using), even if there is more data.
So I guess some modifications could be made, perhaps using BLOB-specific functions. Personally I
would keep long chunks of text away from a Web app, but handling ir carefully...
I'm going to ask the maintainer if some work is currentry being done about this.
You also have to ask yourself if you really need to handle those amounts of data. Perhaps you have
to establish a limitation or split your data among several columns (yeah, I know, I know, but if you
are desperate...)
Greetings,
Paco