Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Yes, the answer I came up with for reading binary data via XHR in IE, is to use VBScript injection. This was distasteful to me at first, but, I look at it as just one more browser dependent bit of code. (The regular XHR and responseText works fine in other browsers; you may have to coerce the mime type with <a href="https://developer.mozilla.org/en/XMLHttpRequest" rel="nofollow noreferrer"><code>XMLHttpRequest.overrideMimeType()</code></a>. This isn't available on IE). </p> <p>This is how I got a thing that works like <code>responseText</code> in IE, even for binary data. First, inject some VBScript as a one-time thing, like this: </p> <pre><code>if(/msie/i.test(navigator.userAgent) &amp;&amp; !/opera/i.test(navigator.userAgent)) { var IEBinaryToArray_ByteStr_Script = "&lt;!-- IEBinaryToArray_ByteStr --&gt;\r\n"+ "&lt;script type='text/vbscript' language='VBScript'&gt;\r\n"+ "Function IEBinaryToArray_ByteStr(Binary)\r\n"+ " IEBinaryToArray_ByteStr = CStr(Binary)\r\n"+ "End Function\r\n"+ "Function IEBinaryToArray_ByteStr_Last(Binary)\r\n"+ " Dim lastIndex\r\n"+ " lastIndex = LenB(Binary)\r\n"+ " if lastIndex mod 2 Then\r\n"+ " IEBinaryToArray_ByteStr_Last = Chr( AscB( MidB( Binary, lastIndex, 1 ) ) )\r\n"+ " Else\r\n"+ " IEBinaryToArray_ByteStr_Last = "+'""'+"\r\n"+ " End If\r\n"+ "End Function\r\n"+ "&lt;/script&gt;\r\n"; // inject VBScript document.write(IEBinaryToArray_ByteStr_Script); } </code></pre> <p>The JS class I'm using that reads binary files exposes a single interesting method, <code>readCharAt(i)</code>, which reads the character (a byte, really) at the i'th index. This is how I set it up: </p> <pre><code>// see doc on http://msdn.microsoft.com/en-us/library/ms535874(VS.85).aspx function getXMLHttpRequest() { if (window.XMLHttpRequest) { return new window.XMLHttpRequest; } else { try { return new ActiveXObject("MSXML2.XMLHTTP"); } catch(ex) { return null; } } } // this fn is invoked if IE function IeBinFileReaderImpl(fileURL){ this.req = getXMLHttpRequest(); this.req.open("GET", fileURL, true); this.req.setRequestHeader("Accept-Charset", "x-user-defined"); // my helper to convert from responseBody to a "responseText" like thing var convertResponseBodyToText = function (binary) { var byteMapping = {}; for ( var i = 0; i &lt; 256; i++ ) { for ( var j = 0; j &lt; 256; j++ ) { byteMapping[ String.fromCharCode( i + j * 256 ) ] = String.fromCharCode(i) + String.fromCharCode(j); } } // call into VBScript utility fns var rawBytes = IEBinaryToArray_ByteStr(binary); var lastChr = IEBinaryToArray_ByteStr_Last(binary); return rawBytes.replace(/[\s\S]/g, function( match ) { return byteMapping[match]; }) + lastChr; }; this.req.onreadystatechange = function(event){ if (that.req.readyState == 4) { that.status = "Status: " + that.req.status; //that.httpStatus = that.req.status; if (that.req.status == 200) { // this doesn't work //fileContents = that.req.responseBody.toArray(); // this doesn't work //fileContents = new VBArray(that.req.responseBody).toArray(); // this works... var fileContents = convertResponseBodyToText(that.req.responseBody); fileSize = fileContents.length-1; if(that.fileSize &lt; 0) throwException(_exception.FileLoadFailed); that.readByteAt = function(i){ return fileContents.charCodeAt(i) &amp; 0xff; }; } if (typeof callback == "function"){ callback(that);} } }; this.req.send(); } // this fn is invoked if non IE function NormalBinFileReaderImpl(fileURL){ this.req = new XMLHttpRequest(); this.req.open('GET', fileURL, true); this.req.onreadystatechange = function(aEvt) { if (that.req.readyState == 4) { if(that.req.status == 200){ var fileContents = that.req.responseText; fileSize = fileContents.length; that.readByteAt = function(i){ return fileContents.charCodeAt(i) &amp; 0xff; } if (typeof callback == "function"){ callback(that);} } else throwException(_exception.FileLoadFailed); } }; //XHR binary charset opt by Marcus Granado 2006 [http://mgran.blogspot.com] this.req.overrideMimeType('text/plain; charset=x-user-defined'); this.req.send(null); } </code></pre> <p>The <a href="https://web.archive.org/web/20130813141732/http://miskun.com/javascript/internet-explorer-and-binary-files-data-access/" rel="nofollow noreferrer">conversion code</a> was provided by Miskun.</p> <p>Very fast, works great.</p> <p>I used this method to read and extract zip files from Javascript, and also in a class that reads and displays EPUB files in Javascript. Very reasonable performance. About half a second for a 500kb file. </p>
    singulars
    1. This table or related slice is empty.
    1. POhow do I access XHR responseBody (for binary data) from Javascript in IE?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKnu
    1. USCheeso
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POhow do I access XHR responseBody (for binary data) from Javascript in IE?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat did you use to read binary data in other browsers? I see your question references a `getBuffer` function. What is that? AFAIK only IE supports `responseBody`. So *what did you use* ??
      singulars
      1. PO
      1. USCrescent Fresh
    2. COI used MSXML2.XMLHTTP in IE, and XMLHttpRequest() in non-IE. In the non-IE browsers, I was able to use responseText to get the byte stream. Apparently IE thinks it is a string, and therefore in IE, beyond the first zero, responseText[i] returns "undefined". But that is not so for FF3.5. It just works.
      singulars
      1. PO
      1. USCheeso
    3. COBut...then it may be a different issue: IE does not allow the `[]` operator on strings. It uses `.charAt(num)` instead. So it may just be you need `responseText.charAt(i)`?
      singulars
      1. PO
      1. USCrescent Fresh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload