To insert a VARCHAR2 into a BLOB column you can rely on the function utl_raw.cast_to_raw as next: insert into mytable(id, myblob) values (1, utl_raw.cast_to_raw(‘some magic here’)); It will cast your input VARCHAR2 into RAW datatype without modifying its content, then it will insert the result into your BLOB column. More details about the function utl_raw.cast_to_raw
Your best option is to use a blob url (which is a special url that points to an object in the browser’s memory) : var myBlob = …; var blobUrl = URL.createObjectURL(myBlob); Now you have the choice to simply redirect to this url (window.location.replace(blobUrl)), or to create a link to it. The second solution allows … Read more
I haven’t had this problem, but you could try length(hex(glob))/2 Update (Aug-2012): For SQLite 3.7.6 (released April 12, 2011) and later, length(blob_column) works as expected with both text and binary data.
Use my code to convert between dataURL and blob object in javascript. (better than the code in your link.) //**dataURL to blob** function dataURLtoBlob(dataurl) { var arr = dataurl.split(‘,’), mime = arr[0].match(/:(.*?);/)[1], bstr = atob(arr[1]), n = bstr.length, u8arr = new Uint8Array(n); while(n–){ u8arr[n] = bstr.charCodeAt(n); } return new Blob([u8arr], {type:mime}); } //**blob to dataURL** … Read more
I found the solution before to post. The change of charset has not been resolved, in fact. However, I sent the UTF-8 header for the download process and Excel was able to understand the file format correctly. Thanks to this response of Erik Töyrä. blob = new Blob([“\ufeff”, csv_content]);
You can do this in two ways: Load the image source using XMLHttpRequest() or fetch() instead of an image element Convert image element via a canvas element. This will recompress the image causing some quality loss. There is also the “risk” of color/gamma changes depending of the image contains ICC/gamma information and/or the browser support … Read more
Blobs are “immutable” so you can’t change one after making it. Constructing a new Blob that appends the data to an existing blob (as you wrote in your initial question) is a good solution. If you don’t need to use the Blob each time you append a part, you can just track an array of … Read more
sqlite3 cannot output binary data directly, so you have to convert the data to a hexdump, use cut to extract the hex digits from the blob literal, and use xxd (part of the vim package) to convert the hexdump back into binary: sqlite3 my.db “SELECT quote(MyBlob) FROM MyTable WHERE id = 1;” \ | cut … Read more
The cause is probably adblock extension (I had exactly the same problem).