CodeIgniter Forums
Can't Uncompress Data Stored to MySQL? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Can't Uncompress Data Stored to MySQL? (/thread-36480.html)



Can't Uncompress Data Stored to MySQL? - El Forum - 12-03-2010

[eluser]Vik[/eluser]
I'm storing a large text file to a MySQL blob field like so:

Code:
$theFile = fopen($thespssDATAfileName, "r+");
$uncompressedDATAFile = addslashes(fread($theFile, filesize($thespssDATAfileName)));
fclose($theFile);

$mysql_query = "UPDATE jobs ";
$mysql_query .= " SET spssDATAfile = (COMPRESS('$uncompressedDATAFile')) ";
$mysql_query .= " WHERE id =  '$theJobID'";
$QueryID = mysql_query($mysql_query);

All appears to go well, and data which appears to be properly compressed is stored in the correct field.

When I try to uncompress it like this:

Code:
$mysql_query = "SELECT UNCOMPRESS(spssDATAfile) FROM jobs ";
$mysql_query .= " WHERE id =  '$theJobID'";
$QueryID = mysql_query($mysql_query);
$theResult = mysql_result($QueryID, 0);

...I get a NULL result.

What am I missing?

Thanks in advance to all for any info.


Can't Uncompress Data Stored to MySQL? - El Forum - 12-03-2010

[eluser]Vik[/eluser]
I got the answer - I had to use a field of type longblob rather than of blob.