How to store a file into MSSQL?
| From: | Javier | Date: | Tue, 15 Jul 2003 22:45:36 +0000 |
| Subject: | How to store a file into MSSQL? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-155328@lists.php.net to get a copy of this message | ||
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)