blob

Viewing Content Of Blob In phpMyAdmin

Sorry for the Noob Question, but what does the circled button mean, and how can I view the content of a blob? ...

Considerations where to store documents - on file server or in DB?

I have a design decision to make regarding documents uploaded to my web site: I can either store them on my file server somewhere, or I can store them as a blob in my database (MSSQL 2005). If it makes any difference to the design decision, these documents are confidential and must have a certain degree of protection. The consideration...

MS Office no longer works as BLOB

Hi does anyone know why MS Office such as doc, docx and xls can no longer be viewed when retrieved from a mysql db when stored as Blob? The doc and docx used to download and open without any problem, but now it no longer recognises the file format. ...

Storing messages as BLOB (Binary Large Object) or ordinary text?

What is the best way to store messaging texts in large/big web sites: BLOB or ordinary text in table or something else? Database: MySQL. ...

Google App Engine: How do I save uploaded text file to Blob, then read from it line by line?

I have a huge file (over 16,000 lines) that I want to save in the datastore for parsing later. Each line contains info on an entity. How do I read line by line from the stored Blob? I can't seem to find a good tutorial or documentation on a Blob anywhere. GAE only shows how to deal with images, but I want to read from the stored te...

Getting a blob size without the blob itself

I have a table that has a blob column representing a file. I'd like to run a LinqToSql query that returns a name and description of the file, along with the file size... but in the interests of not killing performance, I obviously don't want to download the whole blob! var q = from f in MyFiles select new {f.Name, f.Description,...

PHP limited by filesize saving a blob in oracle

Hi, I'm using a php script to save a binary stored in the server's temp directory into oracle as a blob. It works fine for filesizes < 7MB, any larger than that and it just doesn't save. The php post and file upload limit is 32MB. The script stops completely at lob->savefile($tempFile). The general code is below: $stid = oci_parse($con...

Problem storing blob values with Doctrine

Hi, I'm using Doctrine 1.1.2 as my ORM framework in combination with Zend Framework and a MSSQL server back-end. What I am trying to do is to store a blob to the database, but Doctrine is throwing me errors when I try. The column in the database is of type varbinary(max), and the model in Doctrine is configured as follows: $this->hasCo...

PHP mysqli updating a blob value in table does nothing.

I have a variable called $description that has a paragraph of information in it. Some of these descriptions are a sentence or 2, some are long, so im using blobs to save this instead of var char. This statement executes without a problem, but nothing actually gets saved. No errors reported. $query = "UPDATE event SET description=? WHERE...

Use of BLOB giving "java.lang.ClassNotFoundException: oracle.sql.BLOB" in case of SPRING-Hibernate application in case of ORACLE as a database!

Hi all, I am using BLOBs in my SPRING-Hibernate application its, giving "java.lang.ClassNotFoundException: oracle.sql.BLOB" in case of ORACLE as a database! Exactly I am getting following: Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Couldn't initialize OracleLobHandler because Oracle driver classes are not ...

MySQL, C++: Need Blob size to read blob data

How do I get the size of data in a BLOB field in the Result Set? (Using C++ and MySQL Connector C++) In order to read the data from the result set, I have allocate memory for it first. In order to allocate memory, I need to know the size of the blob data in the result set. Searching the web and StackOverflow, I have found two method...

Blackberry way to store audio and video into sqlite?

I want to make a blackberry app. which will store audio and video files into the sqlite database. Does blackberry have a special api for this? (special classes for byte[]) Can I store files into sqlite on blackberry? ...

Displaying a Blob back as a Image in php without header("Content-type: image/jpg");

Im pulling the binary data out of my mySql database and want to display it as a image. I do not want to make a separate page for it to display the image (this would involve a extra call to the databae among other things) I simply want to be able to do Pretty much but the $Image variable is in its longblob format and I need to conve...

Convert blob to text in a mysql export

Hi! I'd have some blob data such as: 0x3333332c2044e963617269652c20356520e9746167650d0a53742d4c617572656e7420285175e9626563292048344e20334d390d0a that I'd like to convert to text because the new database has text field instead of blobs and now it makes trouble with some accentuated characters. Is there somekind of blob to string con...

Binary data under 20KB : BLOB or filesystem ?

I'm developing web app that user can save his/her work to server. The data will be saved is in variable-length binary form, it's size mostly under 20KB (sometimes little bigger < 100KB). The data will often be changed / updated. I have 2 options saving the data in server: as BLOB (mysql) or as filesystem with reference to its filepath s...

dbms_lob.getlength() vs. length() to find blob size in oracle

I'm getting the same results from select length(column_name) from table as select dbms_lob.getlength(column_name) from table However, the answers to this question seem to favor using dbms_log.getlength(). Is there any benefit to using dbms_lob.getlength()? If it changes the answer, I know all of the blobs are .bmp images (nev...

Print a BLOB document

Hello all, I am trying to find a way to print a document that is stored as a BLOB without having to first open it, the filename is stored as well so I have the extension of the file available. The only idea I have had is to save it in the users temporary folder and then point the PrintDocument class to it but im sure theres a better way...

Display MySQL BLOB'd image on webpage without separate script (PHP)

So I've got some images stored in a MySQL database as BLOB's (I know it's better to just store the directory and do it that way, but this is what I need to do for now) and I need to display them on a webpage. Now, I know how to make a script and give it an image header and pull the img src from there, but I have a lot of images from diff...

How do I use BCP or Sql Server Management Studio to get BLOB data out of Sql Server?

I'm sorry if this question has been asked already, but I couldn't find it anywhere. I have a table that stores files as BLOBS. The column that holds the file is an image datatype. I would like to be able to extract the binary data out of the column and turn it in to an actual file. I would ideally like to be able to do this with BCP o...

Parameters to tune when retrieving a lot of small BLOBs (2-10kb) from Oracle DB?

We have a table in which we store millions of small BLOBs (2-10kb). And we need to access a portion of this table at a time, iterating through it while retrieving all these BLOBs (this "portion" is usually in the order of 10**5 rows). We use oracle 11g R1. Right now I am thinking about tuning the OracleConnection.setDefaultRowPrefet...