RE: [PHP] MS SQL server TEXT column
| From: | John W. Holmes | Date: | Thu, 10 Oct 2002 23:21:11 +0000 |
| Subject: | RE: [PHP] MS SQL server TEXT column | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119588@lists.php.net to get a copy of this message | ||
Make sure you're using POST as your form method and not GET.
---John Holmes...
> -----Original Message-----
> From: Vail, Warren [mailto:Warren.Vail@schwab.com]
> Sent: Thursday, October 10, 2002 5:04 PM
> To: php
> Subject: [PHP] MS SQL server TEXT column
>
> Encountered the following problem with the Microsoft SQL Server
interface.
> I am not sure where the problem exists, but I am looking for a
workaround.
>
> I inserted a row into a table that contained a text column, and
inserted
> over 5kb string into the text field. On retrieving the row the server
> returned the column values truncated to 4096 bytes exactly. Tried to
code
> SET TEXTSIZE nnn into my query string, the query refused to return
> anything
> at all. Then I tried coding SET TEXTSIZE as a separate query on the
same
> connection, just prior to my data query, both appeared to be
successful,
> but
> still only got 4096 bytes of data.
>
> select DATALENGTH(availabilitySample) from mftsmainframeavailability
where
> availabilityID = 1
>
> using the MSSQL 7 Query analyzer returns;
>
> -----------
> 5242
>
> (1 row(s) affected)
>
> This shows that my text was stored, I just can't seem to get the
server
> (or
> the interface) to give me back more than 4096 bytes.
>
> any clues would be greatly appreciated.
> thanks in advance,
>
> Warren Vail
> Tools, Metrics & Quality Processes
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php