note 11502 deleted from ref.mssql by sniper
| From: | sniper@php.net | Date: | Mon, 17 Nov 2003 22:57:12 +0000 |
| Subject: | note 11502 deleted from ref.mssql by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-60512@lists.php.net to get a copy of this message | ||
Note Submitter: myers@fil.org
----
> Having trouble with pesky TEXT
> datatypes? Try the query 'set
> textsize 555555555;' to set the limit
> on how much a TEXT will return.
I was trying to figure out why 555555555 works and not anything higher. Then it occured to me ...
the machine in question has 512 MB of ram. The moral of the story is that you have to adjust the
size to how much memory you have and how much data you expect to come out of the database.