Re: How to store a file into MSSQL?

I just use a TEXT field, and am doing so with 25k images, without issue. On Tue, 2003-07-15 at 18:45, Javier wrote: > Hi everybody, I've trying to store a into a MSSQL Server (7 or 2k) using > an example I found on the web (www.php.net). > > Is it possible that PHP (4.3.2) just store 4k of data? Because after > inserting a test image with: > > $oDatos is an object that handles queries. > > // storing a file > $datastring = join('',file("logo2.jpg")); > $data = unpack("H*hex", $datastring); > $oDatos->query( "insert into temp_test (test) values ( 0x" . > $data['hex'] > .")" ); > > A select will return a 4K file. Is it possible? > > $row = $oDatos->getData("select test from temp_test"); > //file://$row = mssql_fetch_assoc($result); > $fp = fopen('copy.jpg','w'); > > > So... is there anyway to store a file that it is larger than 4K? Or am I > missing something? :) > > Thanks. > > -- > *** s2r - public key: (http://leeloo.mine.nu/s2r-gmx.sig) -- Adam Voigt (adam@cryptocomm.com) Linux/Unix Network Administrator The Cryptocomm Group