I&#39;m trying to upload a image in Windows Azure Blob and I&#39;m geting the following error which I can&#39;t handle.

&gt; Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.

The error occurs when I try to create a container.

```cs
container.CreateIfNotExists()
```

Here is my code

```cs
try
{
    Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(ConfigurationManager.AppSettings[&quot;StorageConnectionString&quot;]);
    CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient(); 

    // Retrieve a reference to a container. 
    CloudBlobContainer container = blobClient.GetContainerReference(&quot;samples&quot;);

    // Create the container if it doesn&#39;t already exist.
    // here is the error
    if (container.CreateIfNotExists())
    {
        container.SetPermissions(
            new BlobContainerPermissions
            {
                PublicAccess = BlobContainerPublicAccessType.Blob
            });
    }
    
    CloudBlockBlob blockBlob = container.GetBlockBlobReference(&quot;Image1&quot;);
    using (var fileStream = System.IO.File.OpenRead(@&quot;Path&quot;))
    {
        blockBlob.UploadFromStream(fileStream);
    }
}
catch (StorageException ex1)
{
    throw ex1;
}
```

I have tried a lot of options in my code but still getting the error.


AzureStorage Blob Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature

The requirements for my document management system were:

1. Must be secure from theft by simple copying of directories, files etc.
2. Must be secure against traditional virus infection (infection of physical file)
3. Must be fast to retrieve
4. The repository must not be visible to casual (directory) browsing users etc.

I have decided to store all documents (and scanned images) as blobs in the database and so far my experience is wonderful and document retrieval is blindingly fast as well - it meets all the criteria from above and there are even a couple of additional advantages, such as autostoring documents together with the entity it relates to, easy and fast seaching of contents, removing of all sorts of user activities around opening and naming of documents etc. etc.

My question is - are there any serious risks or things that I overlooked with this design and implementation?

EDIT Note: DB is PostgreSQL, handles BLOBS very well and scales exceptionally well. The environment is Multi-user.

Storing Documents as Blobs in a Database - Any disadvantages?

I have an sqlite table that contains a BLOB file, but need to do a size/length check on the blob, how do I do that?

According to some documentation I did find, using length(blob) won&#39;t work, because length() only works on texts and will stop counting after the first NULL. My empirical tests have shown this to be true.

I&#39;m using SQLite 3.4.2


---

Updates:

So as of SQLite 3.7.6 it appears as though the length() function returns the correct value of blobs - I checked various change-logs of sqlite, but did not see in what version this was corrected.

From Sqlite 3.7.6:
&lt;pre&gt;
payload_id|length(payload)|length(hex(payload))/2
1807913|194|194
1807914|171|171
&lt;/pre&gt;

The [documentation][1] was changed to reflect this.

&lt;pre&gt;
length(X)   The length(X) function returns the length of X in characters if X is
            a string, or in bytes if X is a blob. If X is NULL then length(X) is
            NULL. If X is numeric then length(X) returns the length of a string 
            representation of X.
&lt;/pre&gt;


  [1]: http://www.sqlite.org/lang_corefunc.html

How do I find the length (size) of a binary blob in sqlite

I am having trouble setting the type of a String, it goes like

	public void setTextDesc(String textDesc) {
		this.textDesc = textDesc;
	}

	@Column(name=&quot;DESC&quot;)
	@Lob
	public String getTextDesc() {
		return textDesc;
	}

and it didn&#39;t work, I checked the mysql schema and it remains varchar(255), I also tried, 

	@Column(name=&quot;DESC&quot;, length=&quot;9000&quot;)
	
or

	@Column(name=&quot;DESC&quot;)
	@Type(type=&quot;text&quot;)
	
I am trying to make the type to be TEXT, any idea would be well appreciated!

Text Field using Hibernate Annotation

As typeof returns &quot;object&quot;..

    var MyBlob = new Blob([&#39;test text&#39;], {type : &#39;text/plain&#39;});
    console.log(typeof MyBlob) // &quot;object&quot;

is it too early to ask for a generic solution for checking whether or not a variable is a blob as it is not yet widely supported? Or how should I go about testing for blob type in browsers which already have it implemented?

How to check if a variable is a blob in JavaScript

How can I easily insert a blob into a `varbinary(MAX)` field?

As an example:

thing I want to insert is: c:\picture.png&lt;br&gt;
the table is mytable&lt;br&gt;
the column is mypictureblob&lt;br&gt;
the place is recid=1

How to insert a blob into a database using sql server management studio

what is the easiest way to convert a Blob into a byte array?I am using MYSQL and i want to convert a Blob datatype into a byte array.

Iam using java programming language:)


Easiest way to convert a Blob into a byte array

I have this in my Angular.js controller that downloads a CSV file:

&lt;!-- language: lang-js --&gt;

     var blob = new Blob([csvContent.join(&#39;&#39;)], { type: &#39;text/csv;charset=utf-8&#39;});
     var link = document.createElementNS(&#39;http://www.w3.org/1999/xhtml&#39;, &#39;a&#39;);
     link.href = URL.createObjectURL(blob);
     link.download = &#39;teams.csv&#39;;
     link.click();

This works perfectly in Chrome but not in IE. A browser console log says:

&gt; HTML7007: One or more blob URLs were revoked by closing the blob for
&gt; which they were created. These URLs will no longer resolve as the data
&gt; backing the URL has been freed.

What does it mean and how can I fix it? 

Blob download is not working in IE

How do you set the name of a blob file in JavaScript when force downloading it through `window.location`?

    function newFile(data) {
        var json = JSON.stringify(data);
        var blob = new Blob([json], {type: &quot;octet/stream&quot;});
        var url  = window.URL.createObjectURL(blob);
        window.location.assign(url);
    }

Running the above code downloads a file instantly without a page refresh that looks like:

 **bfefe410-8d9c-4883-86c5-d76c50a24a1d**

I want to set the filename as ***my-download.json*** instead.

JavaScript blob filename without link

I need to upload an image to NodeJS server to some directory. I am using `connect-busboy` node module for that.

I had the `dataURL` of the image that I converted to blob using the following code:

    dataURLToBlob: function(dataURL) {
        var BASE64_MARKER = &#39;;base64,&#39;;
        if (dataURL.indexOf(BASE64_MARKER) == -1) {
            var parts = dataURL.split(&#39;,&#39;);
            var contentType = parts[0].split(&#39;:&#39;)[1];
            var raw = decodeURIComponent(parts[1]);
            return new Blob([raw], {type: contentType});
        }
        var parts = dataURL.split(BASE64_MARKER);
        var contentType = parts[0].split(&#39;:&#39;)[1];
        var raw = window.atob(parts[1]);
        var rawLength = raw.length;
        var uInt8Array = new Uint8Array(rawLength);
        for (var i = 0; i &lt; rawLength; ++i) {
            uInt8Array[i] = raw.charCodeAt(i);
        }
        return new Blob([uInt8Array], {type: contentType});
    }
            
I need a way to convert the blob to a file to upload the image.

Could somebody help me with it?


How to convert Blob to File in JavaScript

What is the maximum length of data I can put in a BLOB column in MySQL?

I am retrieving a Blob image from a database, and I&#39;d like to be able to view that image using JavaScript. The following code produces a broken image icon on the page:

    var image = document.createElement(&#39;image&#39;);
        image.src = &#39;data:image/bmp;base64,&#39;+Base64.encode(blob);
        document.body.appendChild(image);

[Here is a jsFiddle][1] containing all the code required, including the blob. The completed code should properly display an image.

 [1]:http://jsfiddle.net/PDhCy/1/

Using JavaScript to display a Blob

I was studying Blobs, and I noticed that when you have an ArrayBuffer, you can easily convert this to a Blob as follows:

    var dataView = new DataView(arrayBuffer);
    var blob = new Blob([dataView], { type: mimeString });

The question I have now is, is it possible to go from a Blob to an ArrayBuffer?

How to go from Blob to ArrayBuffer

I have an application using hibernate 3.1 and JPA annotations.  It has a few objects with byte[] attributes (1k - 200k in size).  It uses the JPA @Lob annotation, and hibernate 3.1 can read these just fine on all major databases -- it seems to hide the JDBC Blob vendor peculiarities (as it should do).

    @Entity
    public class ConfigAttribute {
      @Lob
      public byte[] getValueBuffer() {
        return m_valueBuffer;
      }
    }

We had to upgrade to 3.5, when we discovered that hibernate 3.5  [breaks (and won&#39;t fix)][1] this annotation combination in postgresql (with no workaround).  I have not found a clear fix so far, but I did notice that if I just remove the @Lob, it uses the postgresql type bytea (which works, but only on postgres).

    annotation                   postgres     oracle      works on
    -------------------------------------------------------------
    byte[] + @Lob                oid          blob        oracle
    byte[]                       bytea        raw(255)    postgresql
    byte[] + @Type(PBA)          oid          blob        oracle
    byte[] + @Type(BT)           bytea        blob        postgresql
    
    once you use @Type, @Lob seems to not be relevant
    note: oracle seems to have deprecated the &quot;raw&quot; type since 8i.

I am looking for a way to have a single annotated class (with a blob property) which is portable across major databases.

 - What is the portable way to annotate a byte[] property?
 - Is this fixed in some recent version of hibernate?

**Update:**
After reading [this blog][2] I have finally figured out what the original workaround in the JIRA issue was: Apparently you are supposed to drop @Lob and annotate the property as:

    @Type(type=&quot;org.hibernate.type.PrimitiveByteArrayBlobType&quot;) 
    byte[] getValueBuffer() {...

However, this does not work _for me_ -- I still get OIDs instead of bytea; it did however work for the author of the JIRA issue, who seemed to want oid.

After the answer from A. Garcia, I then tried this combo, which actually does work on postgresql, but not on oracle.

    @Type(type=&quot;org.hibernate.type.BinaryType&quot;) 
    byte[] getValueBuffer() {...

What I really need to do is control which @org.hibernate.annotations.Type the combination (@Lob + byte[] gets mapped) to (on postgresql).

----------

Here is the snippet from 3.5.5.Final from MaterializedBlobType (sql type Blob).  According to Steve&#39;s blog, postgresql wants you to use Streams for bytea (don&#39;t ask me why) and postgresql&#39;s custom Blob type for oids.  Note also that using setBytes() on JDBC is also for bytea (from past experience).  So this explains why use-streams has no affect they both assume &#39;bytea&#39;.

    public void set(PreparedStatement st, Object value, int index) {
     byte[] internalValue = toInternalFormat( value );
     if ( Environment.useStreamsForBinary() ) {
      // use streams = true
       st.setBinaryStream( index, 
        new ByteArrayInputStream( internalValue ), internalValue.length );
     }
     else {
      // use streams = false
      st.setBytes( index, internalValue );
     }
    }

This results in:

    ERROR: column &quot;signature&quot; is of type oid but expression is of type bytea

**Update**
The next logical question is: &quot;why not just change the table definitions manually to bytea&quot; and keep the (@Lob + byte[])?  This _does_ work, **UNTIL** you try to store a null byte[].  Which the postgreSQL driver thinks is an OID type expression and the column type is bytea -- this is because hibernate (rightly) calls JDBC.setNull() instead of JDBC.setBytes(null) which PG driver expects. 

    ERROR: column &quot;signature&quot; is of type bytea but expression is of type oid

The type system in hibernate is currently a &#39;work in progress&#39; (according to 3.5.5 deprecation comment).  In fact so much of the 3.5.5 code is deprecated, it is hard to know what to look at when sub-classing the PostgreSQLDialect).  

AFAKT, Types.BLOB/&#39;oid&#39; on postgresql should be mapped to some custom type which uses OID style JDBC access (i.e. PostgresqlBlobType object and NOT MaterializedBlobType).  I&#39;ve never actually successfully used Blobs with postgresql, but I do know that bytea just simply works as one / I would expect.

I am currently looking at the BatchUpdateException -- its possible that the driver doesn&#39;t support batching.  

----------
Great quote from 2004:
 &quot;To sum up my ramblings, I&#39;d say they we should wait for the JDBC driver to do LOBs properly before changing Hibernate.&quot;


**References:**

 - https://forum.hibernate.org/viewtopic.php?p=2393203
 - https://forum.hibernate.org/viewtopic.php?p=2435174
 - http://hibernate.atlassian.net/browse/HHH-4617
 - http://postgresql.1045698.n5.nabble.com/Migration-to-Hibernate-3-5-final-td2175339.html
 - https://jira.springframework.org/browse/SPR-2318
 - https://forums.hibernate.org/viewtopic.php?p=2203382&amp;sid=b526a17d9cf60a80f13d40cf8082aafd
 - http://virgo47.wordpress.com/2008/06/13/jpa-postgresql-and-bytea-vs-oid-type/

  [1]: http://hibernate.atlassian.net/browse/HHH-4876
  [2]: http://in.relation.to/Bloggers/PostgreSQLAndBLOBs#comment15505



proper hibernate annotation for byte[]

What is `blob` and what is `text`? What are the differences?

When do I need to use `blob` and when do I need `text` as data type?

Because for `blob` and `text`, there are `mediumblob` == `mediumtext`, `smallblob` == `small text`. Do they even have the same meaning?

And look at this `MEDIUMBLOB`, `MEDIUMTEXT L` + 3 bytes, where `L &lt; 224`.

What is `L`?

What are the differences between the BLOB and TEXT datatypes in MySQL?

I am trying to see from an SQL console what is inside an Oracle BLOB.

I know it contains a somewhat large body of text and I want to just see the text, but the following query only indicates that there is a BLOB in that field:

    select BLOB_FIELD from TABLE_WITH_BLOB where ID = &#39;&lt;row id&gt;&#39;;

the result I&#39;m getting is not quite what I expected:

&lt;pre&gt;
    BLOB_FIELD
    -----------------------
    oracle.sql.BLOB@1c4ada9
&lt;/pre&gt;

So what kind of magic incantations can I do to turn the BLOB into it&#39;s textual representation?

PS: I am just trying to look at the content of the BLOB from an SQL console (Eclipse Data Tools), not use it in code.

How do I get textual contents from BLOB in Oracle SQL

My page generates a URL like this: `&quot;blob:http%3A//localhost%3A8383/568233a1-8b13-48b3-84d5-cca045ae384f&quot;` How can I convert it to a normal address?

I&#39;m using it as an `&lt;img&gt;`&#39;s `src` attribute.


Convert blob URL to normal URL

I have been pretty much fascinated by these two data types. According to **[Oracle Docs][1]**, they are presented as follows :

**BLOB :** Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such as voice or mixed media. BLOB strings are not associated with a character set, as with FOR BIT DATA strings.

**CLOB :** Variable-length character large object string that can be up to 2GB (2,147,483,647) long. A CLOB can store single-byte character strings or multibyte, character-based data. A CLOB is considered a character string.

What I don&#39;t know, is whether there is any difference between the two from DB2 and Oracle perspective? I mean, what are the differences between DB2 CLOB and Oracle CLOB, also between DB2 BLOB and Oracle BLOB? What is the maximum size of both in DB2 and Oracle? Is it just 2 GB ?

  [1]: http://docs.oracle.com/cd/E35137_01/doc.32/e18460/oracle_db2_compared.htm

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been trying to display pdf file which I am getting as a blob from a `$http.post` response. The pdf must be displayed within the app using `&lt;embed src&gt;` for example.

I came across a couple of stack posts but somehow my example doesn&#39;t seem to work.

**JS:**

According to [this doc][1], I went on and tried...

    $http.post(&#39;/postUrlHere&#39;,{myParams}).success(function (response) {
     var file = new Blob([response], {type: &#39;application/pdf&#39;});
     var fileURL = URL.createObjectURL(file);
     $scope.content = fileURL;
    });

Now from what I understand, `fileURL` creates a temporary URL that the blog can use as a reference.

**HTML:**

    &lt;embed src=&quot;{{content}}&quot; width=&quot;200&quot; height=&quot;200&quot;&gt;&lt;/embed&gt;

I am not sure how to handle this in Angular, the ideal situation would be to **(1)** assign it to a scope, **(2)** &#39;prepare/rebuild&#39; the blob to a pdf **(3)** pass it to the HTML using `&lt;embed&gt;` because I want to display it within the app.

I have been researching for more than a day now but somehow I can&#39;t seem to understand how this works in Angular... And let&#39;s just assume the pdf viewer libraries out there weren&#39;t an option.



  [1]: https://developer.mozilla.org/en-US/docs/Web/API/Blob

How to Display blob (.pdf) in an AngularJS app

I&#39;m getting the same results from 

    select length(column_name) from table

as

`select dbms_lob.getlength(column_name) from table` 

However, the answers to
&lt;a href=&quot;https://stackoverflow.com/questions/840966/what-is-an-elegant-way-to-return-a-readable-file-size-of-a-file-stored-in-an-or&quot;&gt;this question&lt;/a&gt; seem to favor using `dbms_lob.getlength()`.  
  
Is there any benefit to using `dbms_lob.getlength()`? 

If it changes the answer, I know all of the blobs are .bmp images (never worked with blobs before).

dbms_lob.getlength() vs. length() to find blob size in oracle

I have a string that I called Blob() on:
    
    var mystring = &quot;Hello World!&quot;;
    var myblob = new Blob([mystring], {
        type: &#39;text/plain&#39;
    });
    mystring = &quot;&quot;;

How do I get the string back out? 

    function getBlobData(blob) {
        // Not sure what code to put here
    }
    alert(getBlobData(myblob)); // should alert &quot;Hello World!&quot;

Javascript - I created a blob from a string, how do I get the string back out?

I want to download a video whose URL is not a simple MP4 file, but rather a blob type for example:

&lt;!-- language: lang-html --&gt;

    &lt;video id=&quot;playerVideo&quot; width=&quot;450px&quot; autoplay=&quot;autoplay&quot; height=&quot;338px&quot; 
           style=&quot;height:100%;width:100%;&quot; class=&quot;mejs-rai-e&quot;
           src=&quot;blob:http://www.example.com/d70a74e1-0324-4b9f-bad4-84e3036ad354&quot;&gt;
    &lt;/video&gt;

Is there any chrome extension or software which can be used to download videos from blob URLs?


How do we download a blob url video

I&#39;m looking for a command line wrapper for the DEFLATE algorithm.

I have a file (git blob) that is compressed using DEFLATE, and I want to uncompress it. The gzip command does not seem to have an option to directly use the DEFLATE algorithm, rather than the gzip format.

Ideally I&#39;m looking for a standard Unix/Linux tool that can do this.

edit: This is the output I get when trying to use gzip for my problem:

    $ cat .git/objects/c0/fb67ab3fda7909000da003f4b2ce50a53f43e7 | gunzip
    
    gzip: stdin: not in gzip format



How to DEFLATE with a command line tool to extract a git object?

 - What is it a BLOB?
 - How can I use it?
 - What are the differences between DBMS&#39;s BLOBs. I would like to save data using BLOBs into any DBMS and then read that BLOB with a library.



What is it exactly a BLOB in a DBMS context

So I&#39;m using an app that stores images heavily in the DB. What&#39;s your outlook on this? I&#39;m more of a type to store the location in the filesystem, than store it directly in the DB.

What do you think are the pros/cons?          

Storing Images in DB - Yea or Nay?

Does amazon s3 support batch uploads? 
I have a job that needs to upload each night ~100K of files that can be up to 1G but is strongly skewed towards small files (90% are less than 100 bytes and 99% are less than 1000 bytes long).

Does the s3 API support uploading multiple objects in a single HTTP call?

All the objects must be available in S3 as individual objects. I cannot host them anywhere else (FTP, etc) or in another format (Database, EC2 local drive, etc). That is an external requirement that I cannot change.

Is it possible to perform a batch upload to amazon s3?

I need to add a UTF-8 byte-order-mark to generated text data on client side. How do I do that?

Using `new Blob([&#39;\xEF\xBB\xBF&#39; + content])` yields `&#39;&#239;&#187;&#191;&quot;my data&quot;&#39;`,  of course.

Neither did `&#39;\uBBEF\x22BF&#39;` work (with `&#39;\x22&#39; == &#39;&quot;&#39;` being the next character in `content`).

Is it possible to prepend the UTF-8 BOM in JavaScript to a generated text?

&lt;sup&gt;Yes, I really do need the UTF-8 BOM in this case.&lt;/sup&gt;

Adding UTF-8 BOM to string/Blob

I want to store an image(from url) into a sqlite database.

For that I use: 

    db = new DataBase(getApplicationContext());
    URL url = new URL(&quot;http://sree.cc/wp-content/uploads/schogini_team.png&quot;);
    URLConnection ucon = url.openConnection();
    InputStream is = ucon.getInputStream();
    BufferedInputStream bis = new BufferedInputStream(is,128);
    ByteArrayBuffer barb= new ByteArrayBuffer(128);
    
    int current = 0;
    while ((current = bis.read()) != -1) {
    	barb.append((byte) current);
    }
    
    ContentValues filedata= new ContentValues();
    
    filedata.put(DataBase.IMG_SRC,barb.toByteArray());
    
    db.insert(DataBase.Table_Img, null, filedata);

In the `Insert()`:

    public void insert(String tableImg, Object object,
    		ContentValues dataToInsert) {
    	// TODO Auto-generated method stub
    	String sql = &quot;INSERT INTO &quot;+tableImg+&quot; (&quot;+ID+&quot;,&quot;+IMG_SRC+&quot;) &quot; +
    			&quot;VALUES (&#39;&quot;+1+&quot;&#39;,&#39;&quot;+dataToInsert+&quot;&#39;)&quot;;
    	db.execSQL(sql);
    }


For the retrieval of image:

    Cursor cursor = db.selectDataToShow(DataBase.Table_Img, DataBase.IMG_SRC);
    
    byte[] imageByteArray=cursor.getBlob(cursor.getColumnIndex(DataBase.IMG_SRC));    	
    cursor.close();
    
    ByteArrayInputStream imageStream = new ByteArrayInputStream(imageByteArray);
    Bitmap theImage = BitmapFactory.decodeStream(imageStream);
    
    System.out.println(&quot;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; &quot;+theImage);

So here I got `null`.

And in my database the value of image stored as: `Image=[B@43e5ac48]`

how to store Image as blob in Sqlite &amp; how to retrieve it?

Why can&#39;t you open the link in the following demo:  
http://html5-demos.appspot.com/static/a.download.html  

You cannot even right click and open it in a new tab/window. Is there any setting in the browser I need to customize?

Open links made by createObjectURL in IE11

I have used sqlite in c++, python and now (perhaps) in C#. In all of these I have no idea how to insert a blob into a table. How do I store and retrieve a blob in sqlite?

How do I store and retrieve a blob from sqlite?

I&#39;m trying to implement Git to manage creative assets (Photoshop, Illustrator, Maya, etc.), and I&#39;d like to exclude files from Git based on file size rather than extension, location, etc.

For example, I don&#39;t want to exclude all .avi files, but there are a handful of massive +1GB avi files in random directories that I don&#39;t want to commit. 

Any suggestions?

gitignore by file size?

How can I insert an image in MySQL and then retrieve it using PHP?

I have limited experience in either area, and I could use a little code to get me started in figuring this out.

How can I store and retrieve images from a MySQL database using PHP?

I found `blob:https://www.facebook.com/c7e5a634-2343-4464-a03e-4a1987301ca1` video source on Facebook&#39;s private group and I really can&#39;t download the video by entering the url nor am I able to decode. Is there any way to decode this?

&lt;!-- begin snippet: js hide: false console: true babel: false --&gt;

&lt;!-- language: lang-html --&gt;

    &lt;video height=&quot;274&quot; width=&quot;476&quot; preload=&quot;auto&quot; style=&quot;&quot; class=&quot;_ox1 _21y0 _1_d1&quot; data-video-width=&quot;476&quot; data-video-height=&quot;274&quot; data-original-aspect-ratio=&quot;1.7387058423913&quot; id=&quot;u_0_27&quot; src=&quot;blob:https://www.facebook.com/dc89feae-5b46-4103-8ee9-da7d7630ca94&quot;&gt;&lt;/video&gt;

&lt;!-- end snippet --&gt;



Decoding facebook&#39;s blob video url

I am working on a business application using `angularJS`. One of my service method returning me a `byte[]` (inclding PDF file content) now i need to download this file as `PDF` to client machine using `JavaScript`.

How is that possible using HTML5 Apis or any JavaScript API?

I have used `window.atob(base64String)`

    JVBERi0xLjMNJeLjz9MNJVBERi1Xcml0ZXIuTkVUIGRiQXV0b1RyYWNrIEx0ZC4NMSAwIG9iag08PA0vVGl0bGUgKEludm9pY2UpDS9BdXRob3IgKFNlcnZpY2VNYW5hZ2VyUGx1cykNL0NyZWF0b3IgKFNlcnZpY2VNYW5hZ2VyUGx1cykNL0NyZWF0aW9uRGF0ZSAoRDoyMDE0MDUwNDE1MDQ0MiswNSczMCcpDS9Nb2REYXRlIChEOjIwMTQwNTA0MTUwNDQyKzA1JzMwJykNPj4NZW5kb2JqDTIgMCBvYmoNWy9QREYgL1RleHQgL0ltYWdlQ10NZW5kb2JqDTMgMCBvYmoNPDwNL1R5cGUgL1BhZ2VzDS9LaWRzIFsgNCAwIFIgNiAwIFIgXQ0vQ291bnQgMg0+Pg1lbmRvYmoNNCAwIG9iag08PA0vVHlwZSAvUGFnZSANL1BhcmVudCAzIDAgUiANL01lZGlhQm94IFsgMCAwIDU5NSA4NDIgXSANL1JvdGF0ZSAwDS9Db250ZW50cyA1IDAgUiANL1Jlc291cmNlcyA8PA0vUHJvY1NldFsvUERGL1RleHQvSW1hZ2VDXQ0vRm9udCA8PCANL0YwIDggMCBSIA0vRjEgMTAgMCBSIA0+Pg0+Pg0+Pg1lbmRvYmoNNSAwIG9iag08PCAvTGVuZ3RoIDEyOTkgL0ZpbHRlciAvRmxhdGVEZWNvZGUgPj4Nc3RyZWFtDQp4nJVZTW/jNhC9+1cQ6KU9rEJKpETllk02LdC0+bCLXAIUqq0kahxpK8vJ5t+XlCxpyKEoJw6CxczjzPO8ITngnlxSElGyeiQLSvSnflp8XS1CQUkiQ7LaLH6+v777nVzfXXy7+4Ws/l18W5HFiVrFulUKzKkCRx34ut7kNfnplCz/uPnCKJXJsKhHsgQg13WeNTnZqD+nhPETGp2ElHEjUzhkEmOiv8qXsnovyXn1+j0rPyao6QWsW8DUypQs909Zva2yR3Lz8v4BuSlonHbUCLEdh1LcPFdlThhIxsxksegifC2226J8ImebTZ3vdtPsYt5FPt/vmuo1r1kYEvBvm0fYhf8tz94+ivKtKtaqhldX5w4o8wZ+KF0xHsqQc3K2Xlf7stH8r7IyZ1ZkcajSMivJZZ2V62K3rnR4ZGBhxMVEsXQr9NVa5vWbYjFTrXaFv1yf+VYPpf7Y3dlX+LNf7lAa2CenRAjxRcRJPKD+Iy0qEkSo76U6uc7JPSl7u2CtncW9nQaJ5KT7y/TWtFGLR7CWGWtto4JqBSTa64kMKE8V2BTjpq7eCrVFIXlG3g9L737FCZaLW6J/NTA+OCmkhKyTnJiMApmIkdT6Od/st/mGLJusbiY54QyAVOgkhayTpEIZBiGPHaQui7LYPU+ywikAq8jJClknWUUpDThPBlZn62afbWfqhMMDRtzJCFknGXEpA8mkzWimSDg+7CdH4wlX44HtNVIf7cy2o8AQhDpaO6kvAkKh/psNgVCoWWZDIBRSdzYEQnnVgBUfgIMgPJXu847xY847iBrPO7TWAZ3YxokIUtWaQs8Ver6p6hdyke/WdfG9KarSe+AZGXwlmQKCetgNiu36ApT9/RemcRDH6vihvNtWF/c+qkY0H1U3cGSr5jXtTmy2SXKEegZqUA+vdUCnDuEkYGlEuIzaKtzlu2q7n9PNjO0rxhQQ+Ki7ENRzrEDMMeltHNAhttO77CguBHkJOIEDiUjtYcEEkRaJKI1bu78ZDNTQDNrKuDCbwTBONkMq1Y7ghNPD2FVXm/26IX9mr7mvG8zgsBqpaJ2hObbYVv/RkqQDoWNOFRwdnvcHp1Ee2zh9EdM0CAGdm1oNdtMzgR0WXhqcYh62cZqHiAOuprmex23zMT0G2EEhC9kxlMZcYhknWQiaBHrE71msqkZNJf6aoOCerWN2t7l5I0mt/THazd53BYYg1K6SWu3qbDCIQg2mnF4ONgh1xlwAG4REVT7pHUcskFcHWGtbh5i7dVD2eR0gCOmgnEfoAFFIB32UzeoAQEiHuQA2COmgfPM6AJBXB1hrWwcu3Too+7wOEIR0UM4jdIAopINyzusAQEiHuQA2COmgfPM6AJBXB1hrW4fDfY50UPZ5HSAI6aCcR+gAUUgH5ZzXAYCQDnMBbBDSQfnmdQAgrw6w1nC00jdkpPyHF7vl/p9GX02n8FbiUr/ThiRtn0NHNp+1W+xN0CT7SeDIXs3l3a2a/bB5h2qodfH7jB3RgSAvbycQ8I7BNIBKHgp3aT9jx4zEkSV3Aoe9G4aqn2j7Qmrs3ePt3aNlGPJA29uXb3sSYkR/ugY2AtjE54G3/Sspk8M4Wjb5ph3Xx8obVdBPgWxc8bf7Z1zbYmkQq+Svi/aL6Relg2WrqOghnY8Bl8VTmTX7GuTXT2p0NuWYswP3OTlLAxGhnLrT+ogX+v86jHdnOZlugHWYPosQPEhoYmT5H418ezgNZW5kc3RyZWFtDWVuZG9iag02IDAgb2JqDTw8DS9UeXBlIC9QYWdlIA0vUGFyZW50IDMgMCBSIA0vTWVkaWFCb3ggWyAwIDAgNTk1IDg0MiBdIA0vUm90YXRlIDANL0NvbnRlbnRzIDcgMCBSIA0vUmVzb3VyY2VzIDw8DS9Qcm9jU2V0Wy9QREYvVGV4dC9JbWFnZUNdDS9Gb250IDw8IA0vRjAgOCAwIFIgDT4+DT4+DT4+DWVuZG9iag03IDAgb2JqDTw8IC9MZW5ndGggMTA1IC9GaWx0ZXIgL0ZsYXRlRGVjb2RlID4+DXN0cmVhbQ0KeJwrVOAyNVAwMjNXMDUwAOOiVIVwhTyuQpIl9N0MFAwNFELSFLgMFECwKJ3LKYTL1ETB3NRUD6QwJIVLwzk/Nzc1r6RYQVMhJIvLNUQBZKChQjlUT5A7pulcwVyBCiBEvEogAgB61iybDWVuZHN0cmVhbQ1lbmRvYmoNOCAwIG9iag08PA0vVHlwZSAvRm9udCANL0Jhc2VGb250IC9DYWxpYnJpIA0vU3VidHlwZSAvVHJ1ZVR5cGUgDS9OYW1lIC9GMCANL0ZpcnN0Q2hhciAzMiANL0xhc3RDaGFyIDI1NSANL1dpZHRocyBbMjI2IDMyNSA0MDAgNDk4IDUwNiA3MTQgNjgyIDIyMCAzMDMgMzAzIDQ5OCA0OTggMjQ5IDMwNiAyNTIgMzg2IDUwNiANNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgMjY3IDI2NyA0OTggNDk4IDQ5OCA0NjMgODk0IA01NzggNTQzIDUzMyA2MTUgNDg4IDQ1OSA2MzAgNjIzIDI1MSAzMTggNTE5IDQyMCA4NTQgNjQ1IDY2MiA1MTYgDTY3MiA1NDIgNDU5IDQ4NyA2NDEgNTY3IDg4OSA1MTkgNDg3IDQ2OCAzMDYgMzg2IDMwNiA0OTggNDk4IDI5MSANNDc5IDUyNSA0MjIgNTI1IDQ5NyAzMDUgNDcwIDUyNSAyMjkgMjM5IDQ1NCAyMjkgNzk4IDUyNSA1MjcgNTI1IA01MjUgMzQ4IDM5MSAzMzQgNTI1IDQ1MSA3MTQgNDMzIDQ1MiAzOTUgMzE0IDQ2MCAzMTQgNDk4IDUwNiA1MDYgDTUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiANNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgMjI2IA0zMjUgNDk4IDUwNiA0OTggNTA2IDQ5OCA0OTggMzkyIDgzNCA0MDIgNTEyIDQ5OCAzMDYgNTA2IDM5NCAzMzggDTQ5OCAzMzUgMzM0IDI5MSA1NDkgNTg1IDI1MiAzMDcgMjQ2IDQyMiA1MTIgNjM2IDY3MSA2NzUgNDYzIDU3OCANNTc4IDU3OCA1NzggNTc4IDU3OCA3NjMgNTMzIDQ4OCA0ODggNDg4IDQ4OCAyNTEgMjUxIDI1MSAyNTEgNjI0IA02NDUgNjYyIDY2MiA2NjIgNjYyIDY2MiA0OTggNjYzIDY0MSA2NDEgNjQxIDY0MSA0ODcgNTE2IDUyNyA0NzkgDTQ3OSA0NzkgNDc5IDQ3OSA0NzkgNzcyIDQyMiA0OTcgNDk3IDQ5NyA0OTcgMjI5IDIyOSAyMjkgMjI5IDUyNSANNTI1IDUyNyA1MjcgNTI3IDUyNyA1MjcgNDk4IDUyOSA1MjUgNTI1IDUyNSA1MjUgNDUyIDUyNSA0NTIgXQ0vRW5jb2RpbmcgL1dpbkFuc2lFbmNvZGluZyANL0ZvbnREZXNjcmlwdG9yIDkgMCBSIA0+Pg1lbmRvYmoNOSAwIG9iag08PA0vVHlwZSAvRm9udERlc2NyaXB0b3IgDS9Bc2NlbnQgNzUwIA0vQ2FwSGVpZ2h0IDUwMCANL0Rlc2NlbnQgLTI1MCANL0ZsYWdzIDMyIA0vRm9udEJCb3ggWyAtNTAzIC0zMDcgMTI0MCA5NjQgXSANL0ZvbnROYW1lIC9DYWxpYnJpIA0vSXRhbGljQW5nbGUgMCANL1N0ZW1WIDAgDT4+DWVuZG9iag0xMCAwIG9iag08PA0vVHlwZSAvRm9udCANL0Jhc2VGb250IC9DYWxpYnJpLEJvbGQgDS9TdWJ0eXBlIC9UcnVlVHlwZSANL05hbWUgL0YxIA0vRmlyc3RDaGFyIDMyIA0vTGFzdENoYXIgMjU1IA0vV2lkdGhzIFsyMjYgMzI1IDQzOCA0OTggNTA2IDcyOSA3MDQgMjMzIDMxMSAzMTEgNDk4IDQ5OCAyNTcgMzA2IDI2NyA0MjkgNTA2IA01MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiAyNzUgMjc1IDQ5OCA0OTggNDk4IDQ2MyA4OTggDTYwNSA1NjAgNTI5IDYzMCA0ODcgNDU4IDYzNyA2MzAgMjY2IDMzMSA1NDYgNDIyIDg3NCA2NTggNjc2IDUzMiANNjg2IDU2MiA0NzIgNDk1IDY1MiA1OTEgOTA2IDU1MCA1MTkgNDc4IDMyNCA0MjkgMzI0IDQ5OCA0OTggMzAwIA00OTMgNTM2IDQxOCA1MzYgNTAzIDMxNiA0NzQgNTM2IDI0NSAyNTUgNDc5IDI0NSA4MTMgNTM2IDUzNyA1MzYgDTUzNiAzNTUgMzk4IDM0NiA1MzYgNDczIDc0NSA0NTkgNDczIDM5NyAzNDMgNDc1IDM0MyA0OTggNTA2IDUwNiANNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IA01MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiA1MDYgNTA2IDUwNiAyMjYgDTMyNSA0OTggNTA2IDQ5OCA1MDYgNDk4IDQ5OCA0MTQgODM0IDQxNiA1MzggNDk4IDMwNiA1MDYgMzkwIDM0MiANNDk4IDMzNyAzMzUgMzAwIDU2MyA1OTcgMjY3IDMwMyAyNTIgNDM1IDUzOCA2NTcgNjkwIDcwMSA0NjMgNjA1IA02MDUgNjA1IDYwNSA2MDUgNjA1IDc3NSA1MjkgNDg3IDQ4NyA0ODcgNDg3IDI2NiAyNjYgMjY2IDI2NiA2MzkgDTY1OCA2NzYgNjc2IDY3NiA2NzYgNjc2IDQ5OCA2ODAgNjUyIDY1MiA2NTIgNjUyIDUxOSA1MzIgNTU0IDQ5MyANNDkzIDQ5MyA0OTMgNDkzIDQ5MyA3NzQgNDE4IDUwMyA1MDMgNTAzIDUwMyAyNDUgMjQ1IDI0NSAyNDUgNTM2IA01MzYgNTM3IDUzNyA1MzcgNTM3IDUzNyA0OTggNTQzIDUzNiA1MzYgNTM2IDUzNiA0NzMgNTM2IDQ3MyBdDS9FbmNvZGluZyAvV2luQW5zaUVuY29kaW5nIA0vRm9udERlc2NyaXB0b3IgMTEgMCBSIA0+Pg1lbmRvYmoNMTEgMCBvYmoNPDwNL1R5cGUgL0ZvbnREZXNjcmlwdG9yIA0vQXNjZW50IDc1MCANL0NhcEhlaWdodCA1MDAgDS9EZXNjZW50IC0yNTAgDS9GbGFncyAzMiANL0ZvbnRCQm94IFsgLTUxOSAtMzA2IDEyNDAgOTcxIF0gDS9Gb250TmFtZSAvQ2FsaWJyaSxCb2xkIA0vSXRhbGljQW5nbGUgMCANL1N0ZW1WIDAgDT4+DWVuZG9iag0xMiAwIG9iag08PA0vVHlwZSAvQ2F0YWxvZyANL1BhZ2VzIDMgMCBSIA0vUGFnZU1vZGUgL1VzZU5vbmUgDS9WaWV3ZXJQcmVmZXJlbmNlcyA8PA0vSGlkZVRvb2xiYXIgZmFsc2UgDS9IaWRlTWVudWJhciBmYWxzZSANL0hpZGVXaW5kb3dVSSBmYWxzZSANL0ZpdFdpbmRvdyBmYWxzZSANL0NlbnRlcldpbmRvdyBmYWxzZSANL0Rpc3BsYXlEb2NUaXRsZSBmYWxzZSANL05vbkZ1bGxTY3JlZW5QYWdlTW9kZSAvVXNlTm9uZSANPj4NPj4NZW5kb2JqDXhyZWYNMCAxMw0wMDAwMDAwMDAwIDY1NTM1IGYgDTAwMDAwMDAwNDggMDAwMDAgbiANMDAwMDAwMDIyMCAwMDAwMCBuIA0wMDAwMDAwMjU2IDAwMDAwIG4gDTAwMDAwMDAzMjEgMDAwMDAgbiANMDAwMDAwMDUwNCAwMDAwMCBuIA0wMDAwMDAxODc3IDAwMDAwIG4gDTAwMDAwMDIwNDggMDAwMDAgbiANMDAwMDAwMjIyNiAwMDAwMCBuIA0wMDAwMDAzMzEyIDAwMDAwIG4gDTAwMDAwMDM0OTEgMDAwMDAgbiANMDAwMDAwNDU4NCAwMDAwMCBuIA0wMDAwMDA0NzY5IDAwMDAwIG4gDXRyYWlsZXINPDwNL1NpemUgMTMgDS9Sb290IDEyIDAgUiANL0luZm8gMSAwIFIgDS9JRFs8QzFEMTBFNDk4OTQ2QkU0RUJFODUzRUNCRDk4OEM1Q0Q+PEMxRDEwRTQ5ODk0NkJFNEVCRTg1M0VDQkQ5ODhDNUNEPl0NPj4Nc3RhcnR4cmVmDTUwMjMNJSVFT0YN

but getting this following error `Failed to execute &#39;atob&#39; on &#39;Window&#39;: The string to be decoded is not correctly encoded.`


Saving binary data as file using JavaScript from a browser

I need download an excel from my backend, its returned a file.

When I do the request I get the error:

&gt; TypeError: You provided &#39;undefined&#39; where a stream was expected. You
&gt; can provide an Observable, Promise, Array, or Iterable.

My code is:

    this.http.get(`${environment.apiUrl}/...`)
          .subscribe(response =&gt; this.downloadFile(response, &quot;application/ms-excel&quot;));

I tried get&lt;blob&gt; and map(...) but didn&#39;t work.

Details: **angular 5.2**

references:

    import { HttpClient } from &#39;@angular/common/http&#39;;
    import &#39;rxjs/add/observable/throw&#39;;
    import &#39;rxjs/add/operator/finally&#39;;
    import &#39;rxjs/add/operator/map&#39;
    import &#39;rxjs/add/operator/catch&#39;;

Content-Type of response:

    Content-Type: application/ms-excel

What&#39;s wrong?


Angular: How to download a file from HttpClient?

I am planning to store a `json_encoded` string on my database. I can&#39;t precisely tell the length its going to be, but I&#39;m pretty sure it will be long. My concern is which field type I am going to use for this, is it `blob` or `text`?

I prefer the one where I can save space as much as possible over fast searching, in any case I have other column where I should just index.

Should I use blob or text for JSON in MySQL?

I&#39;m developping a reactJs application. I&#39;m using jest to test my application.
I want to test a function that download a blob.

But unfortunately I receve this error:
&gt; URL.createObjectURL is not a function

my test function:

 

    describe(&#39;download&#39;, () =&gt; {
        const documentIntial = { content: &#39;aaa&#39; };
        it(&#39;msSaveOrOpenBlob should not have been called when navigao is undefined&#39;, () =&gt; {
          window.navigator.msSaveOrOpenBlob = null;
          download(documentIntial);
          expect(window.navigator.msSaveOrOpenBlob).toHaveBeenCalledTimes(0);
        });
      });

The function I want to test:

    export const download = document =&gt; {
      const blob = new Blob([base64ToArrayBuffer(document.content)], {
        type: &#39;application/pdf&#39;,
      });
      if (window.navigator &amp;&amp; window.navigator.msSaveOrOpenBlob) {
        window.navigator.msSaveOrOpenBlob(blob);
        return;
      }
    
      const fileURL = URL.createObjectURL(blob);
      window.open(fileURL);
    };


Jest URL.createObjectURL is not a function

I&#39;ve got some `byte[]` fields in my entities, e.g.:

    @Entity
    public class ServicePicture implements Serializable {
    	private static final long serialVersionUID = 2877629751219730559L;
    	// seam-gen attributes (you should probably edit these)
    	@Id
    	@GeneratedValue
    	private Long id;
    	private String description;
    
    	@Lob
    	@Basic(fetch = FetchType.LAZY)
    	private byte[] picture;

On my database schema the field is set to `BLOB` so this should be fine. Anyway: Everytime when I try to insert a picture or pdf - nothing bigger than `1mb`, I only recieve this

    16:52:27,327 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 22001
    16:52:27,327 ERROR [JDBCExceptionReporter] Data truncation: Data too long for column &#39;picture&#39; at row 1
    16:52:27,328 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not insert: [de.ac.dmg.productfinder.entity.ServicePicture]
    16:52:27,328 ERROR [STDERR] 	at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
    16:52:27,328 ERROR [STDERR] 	at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:218)
    16:52:27,328 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    16:52:27,328 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    16:52:27,328 ERROR [STDERR] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    16:52:27,328 ERROR [STDERR] 	at java.lang.reflect.Method.invoke(Unknown Source)
    16:52:27,328 ERROR [STDERR] 	at org.jboss.seam.persistence.EntityManagerInvocationHandler.invoke(EntityManagerInvocationHandler.java:46)
    16:52:27,328 ERROR [STDERR] 	at $Proxy142.persist(Unknown Source)

I&#39;ve checked my MySQL cnf and the `max_allowed`param is set to `16M` - am I missing something?

JPA, Mysql Blob returns data too long

I have an odd problem, the function below is one I created based on what i found on the net about creating a Blob in the client on the fly with some binary data in (passed as an array) and being able to download that. This works brilliantly in Chrome, but doesn&#39;t do anything in Firefox - UNLESS I debug and step through the code. Yes, oddly, if I create a break point inside the function and step through it, the a.click() will bring up the download window!

    function downloadFile(filename, data) {
    
    	var a = document.createElement(&#39;a&#39;);
    	a.style = &quot;display: none&quot;;	
    	var blob = new Blob(data, {type: &quot;application/octet-stream&quot;});
    	var	url = window.URL.createObjectURL(blob);
    	a.href = url;
    	a.download = filename;
    	document.body.appendChild(a);
    	a.click();
    	document.body.removeChild(a);
    	window.URL.revokeObjectURL(url);	
    }

Can anyone help me? This was tested using Firefox 38.0.5.


Blob createObjectURL download not working in Firefox (but works when debugging)

Is ok storing files like HTML pages, images, PDF, etc in a table in PostgreSQL or it is slow? I read some articles saying that this is not recommended, but I don&#39;t know if is true.

The column types I have in mind are `BLOB` (as far as I know it stores in a file) or `bytea` type, but others are applicable also.

All Blob Solutions on Gang of Coders

Total of 40 Blob Solutions