Stack Overflow
Stack Overflow

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.

7634 questions
32
votes
5 answers

Varbinary vs Blob in MySQL

I have about 2k of raw binary data that I need to store in a table, but don't know whether to choose the Varbinary or Blob type. I have read through the descriptions in the MySQL docs but didn't find any contract and compare descriptions. I also…
Jimmyb
  • 860
  • 1
  • 8
  • 22
32
votes
5 answers

oracle blob text search

Is it possible to search through blob text using sql statement? I can do select * from $table where f1 like '%foo%' if the f1 is varchar, how about f1 is a blob? Any counter part for this?
Skay
  • 9,343
  • 6
  • 27
  • 28
32
votes
2 answers

Is there any limitation on JavaScript Max Blob size

I am trying to download a file using AJAX call. I need to use AJAX call because I have to make a post request along with that I need to send some headers from the client. As Server API is not under our control, we don't have much choice other than…
Vikash
  • 674
  • 1
  • 5
  • 11
32
votes
8 answers

Spring, Hibernate, Blob lazy loading

I need help with lazy blob loading in Hibernate. I have in my web application these servers and frameworks: MySQL, Tomcat, Spring and Hibernate. The part of database config.
Alexey Khudyakov
  • 383
  • 1
  • 4
  • 10
32
votes
6 answers

Azure Blob always downloads when navigating to url

In our application we give the user the abilty to upload a document to a windows azure blob storage account. After uploading the document or image it gets assigned some url (https://name.blob.core.windows.net/container/file-name.jpg). If the…
Nick Olsen
  • 6,299
  • 11
  • 53
  • 75
31
votes
3 answers

How to store images in your filesystem

Currently, I've got images (max. 6MB) stored as BLOB in a InnoDB table. As the size of the data is growing, the nightly backup is growing slower and slower hindering normal performance. So, the binary data needs to go to the file system. (pointers…
Jacco
  • 23,534
  • 17
  • 88
  • 105
30
votes
2 answers

How do I tell the type of websocket onmessage's parameter?

Here https://developer.mozilla.org/en/WebSockets/WebSockets_reference/MessageEvent it states attribute data is of type DOMString| Blob | ArrayBuffer. How do I tell it which type I want? Or how do I know which type I get?
marc40000
  • 3,167
  • 9
  • 41
  • 63
30
votes
2 answers

Do I always need to call URL.revokeObjectURL() explicitly?

I'm using blob to download files, Problem is I want to keep Object URL even after downloading the file, without making major changes in code base. So one of the option is not to call URL.revokeObjectURL(); Is it safe to depend on browser's…
Basel Issmail
  • 3,847
  • 7
  • 20
  • 36
29
votes
2 answers

Exporting Blob from MySQL database to file with only SQL

I have a table with image data stored in a blob field in a MySQL database. Is there a way to export those images to files on the filesystem by using only SQL? The images should be named {imageId}.jpg I know that it is easy to do this with Java or…
suicide
  • 760
  • 4
  • 13
  • 20
29
votes
1 answer

Search for value within BLOB column in MySQL

How can I search inside Blob column in MySQL for some values ? and Is that possible ?
Zamblek
  • 789
  • 1
  • 12
  • 21
29
votes
3 answers

MySQL - Base64 vs BLOB

For the sake of simplicity, suppose I'm developing a mobile app like Instagram. Users can download images from the server, and upload images of their own. Currently the server stores all images (in reality, just small thumbnails) in a MySQL database…
Hundley
  • 3,167
  • 3
  • 23
  • 45
29
votes
5 answers

What is difference between storing data in a blob, vs. storing a pointer to a file?

I have a question about the blob data type in MySQL. I read that the data type can be used to store files. I also read that an alternative is to store the file on disk and include a pointer to its location in the database (via a varchar column).…
user1832628
  • 3,859
  • 3
  • 16
  • 10
29
votes
2 answers

How do I display the full content of LOB column in Oracle SQL*Plus?

When I try to display the contents of a LOB (large object) column in SQL*Plus, it is truncated. How do I display the whole thing?
Anonymoose
  • 5,662
  • 4
  • 33
  • 41
28
votes
0 answers

How to read a blob data URL in WKWebView?

I have a WKWebView, but when I click on a link that has the following URL: blob:https://www.mycase.com/2963c6c0-24c1-418f-a314-88f7a2dbc713 Nothing happens. Reading the documentation it describes: The only way to read content from a Blob is to use…
Mark
  • 16,906
  • 20
  • 84
  • 117
28
votes
3 answers

HTML5 File API downloading file from server and saving it in sandbox

I'm trying to understand HTML5 API. I'm designing the web application where the browser client need to download multiple files from server; user will perform something with the downloaded files and the application than need to save the state on user…
Mamadum
  • 530
  • 1
  • 9
  • 16
1 2 3
…
99 100