Re: Fields to large for php3

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"" <paul_lewis@csgsystems.com> wrote in message news:007d01c07b0a$abfda4b0$5e21010a@csgsystems.com... > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >