blob

Combining Relational and Document based "Databases"

I am developing a system that is all about media archiving, searching, uploading, distributing and thus about handling BLOBs. I am currently trying to find out the best way how to handle the BLOB's. I have limited resources for high end servers with a lot of memory and huge disks, but I can access a large array of medium performance off...

What is org.springframework.orm.hibernate3.support.BlobByteArrayType good for?

What is org.springframework.orm.hibernate3.support.BlobByteArrayType good for?Why not map a byte[] as the Hibernate basic type "binary"? What are the differences? When to use which? Thanks! ...

ASPNet EMail attachment from SQL BLOB

We are storing scheduled email information in SQL Server 2005. Included in the email information are 0 - 3 attachments of varying filetype. I have a VB.net Windows service that runs 'x' number of minutes, populates a dataset with the email info from SQL Server, builds the emails, and sends them via ASPNet EMail. Trying to build and add ...

Store and retrieve Image by Hibernate

Hi every One, can any one tell me what is the best way to store and Image By hibernate (into MySQL) I have this class Mapping @Entity @Table(name = "picture") public class PictureEntity implements Serializable { @Id @Column(name = "id") @GeneratedValue private int id; @Column(name = "format", length = 8) private...

Workaround for Oracle 9i outputting CRLF when using utl_file.putraw() for BLOBs?

Hi I'm writing a database procedure to archive data in an Oracle 9i table that contains BLOBs. Because the database size has grown too large, our strategy is to export the BLOBs to the file system (Windows 2000 server), where they can be backed up on tape, then to truncate the database table. Here's my procedure that saves a BLOB to di...

Extra Bytes in File Extracted from SQL Server 2000 Database

I am migrating all my company's customer data to a new CRM system, and the old legacy database is on a SQL Server 2000 server. I can extract all data in the tables via T-SQL queries but run into a brick wall when it comes to file attachments. They are stored as BLOBs in an Image column in the legacy database. After several fruitless exp...

Storing very large integers in MySQL

I need to store a very large number (tens of millions) of 512-bit SHA-2 hashes in a MySQL table. To save space, I'd like to store them in binary form, rather than a string a hex digits. I'm using an ORM (DBix::Class) so the specific details of the storage will be abstracted from the code, which can inflate them to any object or structure...

SQL Server 2005/2008: Insert a File in an varbinary(max) column in Transact-SQL.

Is it possible to insert a file in a varbinary(max) column in Transact-SQL? If yes, I would be very please to have a code snippet to at least give me an idea how to do that. Thanks ...

can Mysql or sqlite Blob data type store varchar data in it?

Hi All, Can one anyone provide any information on whether can we store normal text data(varchar) in mysql or sqlite Blob data type ...

mysql insert syntax for blob data through Stored procedure

Hi All, I want to insert an img file in mysql database, can anyone provide normal insert statement for inserting blob into mysql database. How i can do it as if i specify the path it stores the path only not the img ...

ResultSet.getBlob() Exception

The Code: ResultSet rs = null; try { conn = getConnection(); stmt = conn.prepareStatement(sql); rs = stmt.executeQuery(); while (rs.next()) { Blob blob = rs.getBlob("text"); byte[] blobbytes = blob.getBytes(1, (int) blob.length()); String text = new String(blobbytes); The result: java.sql.SQLExc...

Store tiff images in SQL Server or file system?

Our system needs to store tiff images of about 3k each in size. We received about 300 at a time, and need to process them pretty quickly. Later, once we have received say around 100,000 of these, there are transferred off to another archival system or purged. Would storing the images in SQL Server or the file system give us better per...

Problem with fetching a BLOB column in PHP + MySQLi

Here's the code: $conn = new mysqli('localhost', 'user', 'password', 'db'); $stmt = $conn->prepare('select Data from sessions'); $stmt->execute(); $x = 234; $stmt->bind_result($x); $stmt->fetch(); var_dump($x); This outputs: string '' (length=0) In fact the table contains exactly one row and the blob column contains some valid ...

Why am I getting [BLOB - 0] when I insert an image into a database using prepared statements?

Hi all, This one's been puzzling me for a bit; hope folks can offer some suggestions! I'm uploading some video details and a thumbnail image to a database using prepared statements. When I do the upload, everything appears to work perfectly -- no SQLi errors or anything -- yet, when I look at the database, I notice that my image_conte...

Correct usage of MySQL LOAD_FILE()

Hi all, I apologize if this is a dense question, but I'm having a bit of trouble using MYSQL LOAD_FILE() in conjunction with prepared statements in order to upload an image BLOB. As a result, I'm having to resort to using to separate queries, one to prepare a statement for details, and another, which doesn't prepare the statement to ins...

Text Field using Hibernate Annotation

I am having trouble setting the type of a String, it goes like public void setTextDesc(String textDesc) { this.textDesc = textDesc; } @Column(name="DESC") @Lob public String getTextDesc() { return textDesc; } and it didn't work, I checked the mysql schema and it remains varchar(255), I also tried, @Column(name="DESC", length="900...

Error creating spatial index on MySql BLOB column

Hi, I am trying to add a spatial index to a table column named Location of type BLOB. If I try this: ALTER TABLE route ADD SPATIAL INDEX(Location); I get: Error: BLOB/TEXT column 'Location' used in key specification without a key length But in the official docs for MySql 5.1 (the version I am using), it clearly says when...

Copy blob data from one table to another on MySQL

I need to copy a set of data from one table to another that includes a BLOB column. I'm using an INSERT query with a subquery SELECT: INSERT INTO dest_table(field1,field2,field3,blobfield,field4) (SELECT t.myfield1,t.myfield2,t.id,t.blobfield,'SomeConstant' FROM tablename t) All fields get copied correct, except the BLOB. I know I'm m...

How to insert / retrieve a file stored as a BLOB in a MySQL db using python

I want to write a python script that populates a database with some information. One of the columns in my table is a BLOB that I would like to save a file to for each entry. How can I read the file (binary) and insert it into the DB using python? Likewise, how can I retrieve it and write that file back to some arbitrary location on th...

[PyQt4] Load blob image data into QPixmap

Hi, I am writing a program using PyQt4 for front-end GUI and this program accesses a back-end database (which can be either MySQL or SQLite). I need to store some image data in the database and below is the Python code I use to import image files (in JPEG format) to a blob data field in the database: def dump_image(imgfile): i = o...