blob

GIt - get all commits and blobs they created

Is there a git command that can output for every commit: id subject blobs it created with they path and size (like git ls-tree -l -r <commit> but only for created blobs) ...

BLOB data to simple string in DataGridView?

I am using C# & MYSQL to develop a desktop application. In one of my form I have a DataGridView (dgvBookings) and in my database table I have a table tblBookings which contains a field specialization of type BLOB. I am selecting data with following query, SELECT * FROM tblBookings WHERE IsActive=1; and then binding the data with Da...

Problem with updating blob, if blob contains specific data

I have binary data that needs to be stored in a BLOB field in a SQL-database. In case of an UPDATE (storing into the database), the binary data comes as a string (BDS2006, no unicode). When the BLOB field is READ, the binary data needs to be returned as a string. Therefore, I have used these two pieces of code (qry is a TQuery): READ: ...

Saving images: files or blobs?

When you save your images (supose you have lots of them) do you store then as blobs in your Database, or as files? Why? Duplicate of: http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay ...

Using a handler to render an image from a blob on an ASP.NET page. I can't get it.

I'm working on a simple image tagging and searching app. I've got my images uploading to the DB, the tags being applied, but am failing when I pull them back - the images don't render. I found this here on SO, but I'm not able to get it working. I think I am perhaps misunderstanding handlers. In short, in the code behind, I'm creating...

Reading a Java BLOB object stored a database using .NET

Hi All, I have an xml file which is stored in an "image" column in an MSSQL database. This field is being set by a java program i do not have access to. I have been told its just a standard Java "blob" object. Is there anyway for me to read this field from the db in .NET and decode it into a readable string? I have close to no Java k...

Serialization, deserialization of void pointers

I would like to store a void pointer in a blob for a record in a table. How do we do the serialization and deserialization? ...

Crystal reports - PUSH blob data, image doesn't display

I've a crystal report that I'm trying to get a dynamic image displayed. This is the CRBasic 2008 version that comes with VS 2008, so i can't use the method where we link out to the file, it has to come from the data source. I'm pushing a strongly typed dataset to the report, which contains a byte[] field. This dataset is being populat...

Inserting raw (binary?) image data into mysql? (PHP)

I've got a raw/(binary?) image like this: ÿØÿà�JFIF��–�–�*!!!$'$ &(goes on forever); when i try to insert this into mysql it doesn't work, the column type is set to longblob, any ideas? ...

storing multiple values as binary in one field

Hi I have a project where I need to store a large number of values. The data is a dataset holding 1024 2Byte Unsigned integer values. Now I store one value at one row together with a timestamp and a unik ID. This data is continously stored based on a time trigger. What I would like to do, is store all 1024 values in one field. So would ...

Detecting File Compression

I have to read some data stored by a third party application in an Acess 2000 database. The vendor is no longer around to ask questions. One table contains image data that appears to be compressed - because the original application can export the contents of the blob field to an embedded png image in a xls export file. I have extracte...

Is it safe to convert a mysqlpp::sql_blob to a std::string?

I'm grabbing some binary data out of my MySQL database. It comes out as a mysqlpp::sql_blob type. It just so happens that this BLOB is a serialized Google Protobuf. I need to de-serialize it so that I can access it normally. This gives a compile error, since ParseFromString() is not intended for mysqlpp:sql_blob types: protobuf.Pars...

permalink_fu for text fields: How can I convert from blob to string output?

If I use permalink_fu on a text field I get this for the resulting permalink: http://localhost:3000/243webb4ee4ff2227230b4232438591810c35d3f instead of http://localhost:3000/where-is-my-lost-cat I assume this is because the text field becomes a blob in the database and permalink_fu only knows how to operate on string fields. How ...

Large .PDF Files Not Uploading To MySQL Database as Medium BLOB Via PHP, Files under 2MB Work Fine

I am developing a PHP script for uploading .PDF documents as medium BLOBs into a MySQL database via PHP. The script also allows users to search for files and open/download them but I do not think that part of the script is relevant to my issue. The script works fine with files less than 2 MB but as soon as I try and upload a file that ...

BLOB Download Truncated at 1 MB Script Works for Files Less Than 1 MB

I just recently asked and solved a question pertaining to uploading .PDF files that are greater than 2 MB into a MySQL database as BLOBS. I had to change some settings in my php.ini file and MySQLs maximum packet setting. However, fixing this issue has led me to discover a new issue with my script. Now since I can upload files to my ...

Blob into Oracle: about 15% are filled with \00

Under Weblogic 10, I am using Hibernate to store data into several tables with BLOBs. It's always worked fine but the customer found specific circumstances where 15% of the BLOBs have the correct size but only contain null characters. I can't figure out what makes it good or full of emptiness. The BLOB type I am using does a: public vo...

How to Store BLOB data in Sqlite Using Tcl

Hello: I have a Tcl TK application that has a Sqlite back-end. I pretty much understand the syntax for inserting, manipulating, and reading string data; however, I do not understand how to store pictures or files into Sqlite with Tcl. I do know I have to create a column that holds BLOB data in Sqlite. I just don't know what to do on ...

FILESTREAM files being left behind after row deleted

I have successfully set up FILESTREAM on my SQL 2008 server; however I've noticed that even when I have deleted rows containing FILESTREAM data, the physical data file doesn't seem to get deleted. By the physical file, I mean the file in SQLServer's managed directory with a uniqueidentifer as the filename not the original file added to ...

Managed local storage for blobs

The general consensus these days seems to be that you do not store binary large objects in your relational database, as its not really optimised for that sort of thing, and instead put it into a dedicated storage engine. Can anyone suggest a solution for the .Net platform, along the lines of the Microsoft Azure Blob Storage engine, but ...

How can I store and retrieve images from a MySQL database using PHP?

How can I insert an image in MySQL and then retrieve it using PHP? I have limited experience in either area, and I could use a little code to get me started in figuring this out. ...