Все вопросы: [blob]

107 вопросов

0
голосов
1ответов
310 просмотров

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 kn...

0
голосов
1ответов
477 просмотров

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 ...

3
голосов
5ответов
995 просмотров

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 im...

0
голосов
2ответов
508 просмотров

storing multiple values as binary in one field

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 ...

0
голосов
2ответов
1911 просмотров

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?

0
голосов
1ответов
2654 просмотров

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 by...

-4
голосов
1ответов
304 просмотров

Is it possible to serialize and deserialize a void pointer to & from a blob in a database?

I would like to store a void pointer in a blob for a record in a table. Is this possible, and if so, how do I do it? I'm using VC++.

0
голосов
2ответов
655 просмотров

Reading a Java BLOB object stored a database using .NET

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 s...

0
голосов
3ответов
2125 просмотров

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. ...

20
голосов
10ответов
43764 просмотров

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: Storing Images in DB - Yea or Nay?

2
голосов
1ответов
5337 просмотров

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 ...

2
голосов
3ответов
7466 просмотров

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 I...

16
голосов
6ответов
18797 просмотров

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)

7
голосов
3ответов
10968 просмотров

Load blob image data into QPixmap

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:...

13
голосов
2ответов
23097 просмотров

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 ...

6
голосов
1ответов
4969 просмотров

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...

2
голосов
2ответов
2871 просмотров

Error creating spatial index on MySql BLOB column

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 vers...

49
голосов
2ответов
74740 просмотров

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), ...

0
голосов
1ответов
1749 просмотров

Correct usage of MySQL LOAD_FILE()

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 do...

0
голосов
1ответов
761 просмотров

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 ex...

2
голосов
4ответов
3558 просмотров

What storage location, SQL Server or file system, would result in better performance in saving tiff images?

Our system needs to store tiff images of ~3k in size. We receive ~300 images at a given time and need to quickly process them. Once ~100,000 images are received, the images are transferred off our system to another archival system or purged. I am looking for best performance in regards to the in...

2
голосов
1ответов
2597 просмотров

mysql insert syntax for blob data through Stored procedure

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

0
голосов
4ответов
1866 просмотров

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

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

16
голосов
1ответов
22682 просмотров

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

14
голосов
2ответов
8112 просмотров

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 c...

1
голосов
3ответов
3576 просмотров

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

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'...

4
голосов
1ответов
8664 просмотров

Store and retrieve Image by Hibernate

I want to know what is the best way to store an image with help of 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 = "...

0
голосов
1ответов
1262 просмотров

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 v...

5
голосов
1ответов
817 просмотров

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!

1
голосов
3ответов
557 просмотров

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 acce...