I am using MySQL (dont think im a MySQL preacher, im not) and Ive used
LONGBLOBS to store 100K+ binary images and sucessfully retreaved them, no
problem. I almost wonder if the problem is in the fieldtype in MSSQL? is it
set to LONGBLOB ? MSSQL might not even have such a field (postgres's largest
field I *think* is 4k). the only solution I can think of in such a case is
to store a unique filename in the field to reference the data from a file.
You could split the data up into 4k chucks using
<?
$data = chunk_split($date, 4096, '||||||||||');
$data = explode('||||||||||', $data);
?>
I dont know if this is the best idea, but it may work, you would then of
course have to retreave X number of fields and peice the data together
again...
Chris Lee
Mediawaveonline.com
""Paul Lewis"" <[EMAIL PROTECTED]> wrote in message
007d01c07b0a$abfda4b0$[EMAIL PROTECTED]">news:007d01c07b0a$abfda4b0$[EMAIL PROTECTED]...
> I have an application that stores large text fields in MS SQL SVR and when
> they are entered on-line everything works fine. The problem begins when I
> try to retrieve them from the database and populate a field on the php3
> on-line form. The query will only return the first 4096 byte of the
> information in the data base field.
>
> I have been told there is a work around, but don't know where to find it.
> Splitting the field up in to smaller chunks is not an option.
>
> Can anyone help me with this problem.
>
> Thanks
> PaulL
>
>
> --
> PHP General 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 General 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]
