Questions tagged [blob]

A BLOB is a collection of binary data stored as a single entity in a database management system.

A BLOB (binary large object, basic large object, BLOB, or BLOb) is a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.

Beyond that, the term BLOB has various slightly related usages, see wikipedia for further examples.

6734 questions
2
votes
0 answers

Can't get Blob info from derby DB

I have Derby DB V 10.12.1.1 with one table: CREATE TABLE APP.JACKRABBIT_X0020_CORE_NODE ( NODE_ID CHAR(36) NOT NULL, NODE_DATA BLOB(2147483647) NOT NULL ); There are some rows which I can read without any problem but there is one row…
Taras
  • 21
  • 2
2
votes
1 answer

How to insert BLOB data from file with Bookshelf.js with node.js?

I am handling file uploads, using multer, in node.js. I need to store the file data in a blob field in a table. Is there a way to bind a file pointer to Bookshelf.js?
vintorg
  • 197
  • 3
  • 17
2
votes
1 answer

Oracle Temporary Table to convert a Long Raw to Blob

Questions have been asked in the past that seems to handle pieces of my full question, but I'm not finding a totally good answer. Here is the situation: I'm importing data from an old, but operational and production, Oracle server. One of the…
Paul Kehle
  • 31
  • 8
2
votes
2 answers

Download blob (text file) from Azure storage to memory as UTF8?

I'm downloading a textfile from my blob storage, and I'd like to preserve the contents of the file (encoding and such). Is there a difference between downloadText() and downloadText("UTF-8",null,null,null) ? Or is there a better way? Some test…
Baked Inhalf
  • 2,358
  • 21
  • 38
2
votes
2 answers

Open file stored in SQLite as blob

As the title, I create a ByteArray to store the file in blob like this: byte[] red_buf = myCursor.getBlob(1); And I wanna use FileOutputStream to open. But I don't know how to do. Can anyone give me a example or website please ??
Kooper
  • 715
  • 1
  • 10
  • 13
2
votes
1 answer

BLOB in MySQL view instead of the proper data

I created a MySQL view using UNION ALL from two tables so that I would get the same column names for the same data in those tables (i.e. tbl1.author2 AS translator ... tbl2.translator AS translator) and so on, the problem is when I try to select…
cypher
  • 6,574
  • 3
  • 28
  • 46
2
votes
1 answer

Display BLOB object in Java web project avoiding persistent cross site scripting?

How do I display data stored as a BLOB object in a Java web project and avoid a persistent cross site scripting vulnerability? The method respond() in ViewDeliveredReportsPage.java sends un-validated data to a web browser on line 2775, which can…
Karan
  • 21
  • 2
2
votes
1 answer

Pop up message if blob is detected, MATLAB

I am working on a fire detection program in MATLAB, and I have a blob detection as part of it. I would like to ask how to put a pop up warning message when a blob has been detected? I want to have a warning message as soon as there's a fire. This…
rowe
  • 23
  • 3
2
votes
1 answer

How to download a file generated with JavaScript, avoiding automatic opening of Chome?

I am developing a JavaScript little webmail. I receive from the server a Base64-encoded string, that represents a file (it could be whatever type). I decode the string, a map it to a Uint8Array, and with it, I generate a Blob object with I create a…
ciaoben
  • 2,217
  • 2
  • 19
  • 36
2
votes
2 answers

How to convert Blob object of unknown format to String or xml in java

I have a blob object which I am trying to convert to String or XML format. I am not able to properly serialize it as I don't know the format. How can I convert this blob? Blob blob = rs.getBlob(4); StringBuffer strOut = new StringBuffer(); …
Umesh Kumar
  • 1,167
  • 2
  • 12
  • 26
2
votes
0 answers

Liquibase error finding parent directory when using valueClobFile attribute

I am currently using liquibase to carry out an update to an existing table in a sql database. I have included the xml script which I have written below. The problem occurs when trying to use the valueClobFile attribute. I am trying to specify a file…
Jaypes
  • 21
  • 1
2
votes
0 answers

Audio play from SQlite Blob in Swift

I am using sqlite3 with fmdb and xcode6.1 (swift). I store my audio file to a sqlite database (as BLOB) and now I want to gain it from db and also play it when a button clicked. When I extracted the audio files from db,it is outputed as "ID3". What…
fiona
  • 53
  • 2
  • 7
2
votes
1 answer

When is a value downloaded from SQL Server (for performance)

Using a normal SqlDataReader from an SqlCommand with SqlConnection, I am wondering: When is a value downloaded from the sql server to my machine? Is it when I call reader.Read() or when I actually fetch the value with reader.GetBytes? My primary…
Inrego
  • 1,393
  • 13
  • 25
2
votes
2 answers

Wav to Blob in nodejs

I'm not sure how to create a blob from a wav file in node. Do I just use Buffer like so?... var blippityBlob = new Buffer(filePathToWave);
RadleyMith
  • 1,203
  • 10
  • 17
2
votes
2 answers

Inserting and reading blob memsql

I'm trying to insert blob in my MemSQL database. This is where I get my source to insert, so I convert it into a blob : byte[] bytes = rs.getString(2).getBytes("utf-8"); Blob blob = insert.insertTableBinary(bytes); This is my insertTableBinary…
Spierki
  • 231
  • 5
  • 15
1 2 3
99
100