i store blob data with php like this\[code\]$this->_db->exec"CREATE TABLE media (url TEXT, content BLOB)");$fp = fopen($encoded['path'], 'rb');$sql = "INSERT INTO media (url, content) VALUES (?, ?)";$stmt = $this->_db->prepare($sql);$stmt->bindValue(1, $encoded['url'], PDO:
ARAM_STR);$stmt->bindValue(2, $fp, PDO:ARAM_LOB);$stmt->execute();fclose($fp);\[/code\]And in my c++ program (using bada framework) i read the data from blob column back. The problem is, when i use php on my localhost (version 5.3.2-1ubuntu4.2), my c++ app can recognize the blob column as blob type correctly. But when i use my remote host (php version 5.2.12) to create sqlite file, my c++ app recognizes the blob column as TEXT TYPE and my binary data is corrupted.Does anyone know why and any work around?Thanks
ARAM_STR);$stmt->bindValue(2, $fp, PDO:ARAM_LOB);$stmt->execute();fclose($fp);\[/code\]And in my c++ program (using bada framework) i read the data from blob column back. The problem is, when i use php on my localhost (version 5.3.2-1ubuntu4.2), my c++ app can recognize the blob column as blob type correctly. But when i use my remote host (php version 5.2.12) to create sqlite file, my c++ app recognizes the blob column as TEXT TYPE and my binary data is corrupted.Does anyone know why and any work around?Thanks