4096 Truncation of Text Fields in MSSQL
| From: | Flint Doungchak | Date: | Fri, 11 Aug 2000 23:27:24 +0000 |
| Subject: | 4096 Truncation of Text Fields in MSSQL | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-1746@lists.php.net to get a copy of this message | ||
Hi,
I'm using 3.0.11 with IIS 4.0 on NT with SP6a. The database I'm using is SQL
Server 7.0 SP2. When I select fields out of a database it truncates the text
fields to 4096 characters.
I found a posting that says I should insert the following into the php3.ini
file:
[MSSQL]
mssql.textsize = 8096 ; or whatever maxsize
mssql.textlimit = 8096 ; or whatever maxsize
However, that doesn't seem to work at all (i.e. it's truncating at 4,096
characters still). I'm using the php_mssql70.dll that is packaged with
php.4.0. It works fine everywhere else (meaning I'm not getting the problems
I got with PHP 4.01 pl2, hence, why I'm using 3.0.11).
Any ideas?
-Flint
________________________________________________
Flint Doungchak, Web Applications Development
Net Solutions LLC
840 Lawrence Street
Eugene, OR 97401
VOICE (541) 345-7087 FAX (541) 485-5519
flint@netsolutionsllc.com
www.netsolutionsllc.com