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
19
votes
3 answers

How to create a java.sql.Blob object in Java SE 1.5.0 with a byte[] input?

I want to create a Blob object from a byte[] input to update a table using PreparedStatement#setBlob(). In J2SE 6, we have java.sql.Connection#createBlob() to get this done. Is there anything similar to this available in J2SE 1.5.0? What is the best…
ssethupathi
  • 363
  • 1
  • 3
  • 11
19
votes
5 answers

When is using MySQL BLOB recommended?

I'm coding an application that will be uploading and deleting many files, i usually just move the files to a folder in the server naming them with the row unique id. But as i understand MySQL also lets me store binary data (files) when would this be…
amosrivera
  • 26,114
  • 9
  • 67
  • 76
19
votes
4 answers

Set File Name while downloading via blob in Angular 5

Below is my Typescript code to download file From API DownloadLM() { var ID= sessionStorage.getItem("UserID"); return this.http.get(this.baseurl + 'api/DownloadFiles/DownloadLM/' + ID, { headers: { 'Content-Type':…
Tanwer
  • 1,503
  • 8
  • 26
  • 41
19
votes
2 answers

Conditions (like "like") on binary field (blob) in oracle

How can I search in (put condition on) blob field in oracle, like text fields? I need someting like: select * from table_name where blob_field like '%00ff00ff%' Oracle throws some error on it.
Polygon
  • 191
  • 1
  • 1
  • 3
19
votes
1 answer

Get-AzureStorageBlob : Could not get the storage context. Please pass in a storage context or set the current storage context

I am using powershell with Azure cmdlets to try and simply see items in blob storage $StorageContext = New-AzureStorageContext -StorageAccountName 'myblobname' -StorageAccountKey '2341231234asdff2352354345==' $Container =…
Peter PitLock
  • 1,823
  • 7
  • 34
  • 71
19
votes
5 answers

PDF Blob is not showing content, Angular 2

I have problem very similar to this PDF Blob - Pop up window not showing content, but I am using Angular 2. The response on question was to set responseType to arrayBuffer, but it not works in Angular 2, the error is the reponseType does not exist…
Loutocký
  • 822
  • 2
  • 15
  • 28
19
votes
1 answer

Serve image stored in SQLAlchemy LargeBinary column

I want to upload a file and store it in the database. I created a LargeBinary column. logo = db.Column(db.LargeBinary) I read the uploaded file and store it in the database. files = request.files.getlist('file') if files: event.logo =…
eyettea
  • 1,376
  • 2
  • 16
  • 35
19
votes
2 answers

OpenCV return keypoints coordinates and area from blob detection, Python

I followed a blob detection example (using cv2.SimpleBlobDetector) and successfully detected the blobs in my binary image. But then I don't know how to extract the coordinates and area of the keypoints. Here are the code for the blob detections: # I…
J_yang
  • 2,672
  • 8
  • 32
  • 61
19
votes
6 answers

Which data type should be used for saving images in database?

We are developing an E-commerce website using ASP.net and SQL server. The customer can view and order a wide variety of switches and light fittings. As we need to display images of these products for each category, the number of images we need to…
Supreeth sup
  • 279
  • 1
  • 4
  • 15
19
votes
4 answers

Can I get a blob by using its url?

I am storing the Azure blob url into my database.Can I get the blob by using that url? Actually I need to update the blob and while doing that I need validations. So I need to convert that database entity model to my local model and apply the…
Bharat Bhushan
  • 1,315
  • 3
  • 18
  • 24
19
votes
4 answers

Loading audio via a Blob URL fails in Safari

Following code works in Chrome (22.0) but not in Safari (6.0)