Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I suppose C# and Java produce equal byte arrays. If you have non-ASCII characters, it's not enough to add an additional 0. My example contains a few special characters:</p> <pre><code>var str = "Hell ö € Ω "; var bytes = []; var charCode; for (var i = 0; i &lt; str.length; ++i) { charCode = str.charCodeAt(i); bytes.push((charCode &amp; 0xFF00) &gt;&gt; 8); bytes.push(charCode &amp; 0xFF); } alert(bytes.join(' ')); // 0 72 0 101 0 108 0 108 0 32 0 246 0 32 32 172 0 32 3 169 0 32 216 52 221 30 </code></pre> <p>I don't know if C# places BOM (Byte Order Marks), but if using UTF-16, Java <code>String.getBytes</code> adds following bytes: 254 255.</p> <pre><code>String s = "Hell ö € Ω "; // now add a character outside the BMP (Basic Multilingual Plane) // we take the violin-symbol (U+1D11E) MUSICAL SYMBOL G CLEF s += new String(Character.toChars(0x1D11E)); // surrogate codepoints are: d834, dd1e, so one could also write "\ud834\udd1e" byte[] bytes = s.getBytes("UTF-16"); for (byte aByte : bytes) { System.out.print((0xFF &amp; aByte) + " "); } // 254 255 0 72 0 101 0 108 0 108 0 32 0 246 0 32 32 172 0 32 3 169 0 32 216 52 221 30 </code></pre> <p><strong>Edit:</strong></p> <p>Added a special character (U+1D11E) MUSICAL SYMBOL G CLEF (outside BPM, so taking not only 2 bytes in UTF-16, but 4.</p> <p>Current JavaScript versions use "UCS-2" internally, so this symbol takes the space of 2 normal characters.</p> <p>I'm not sure but when using <code>charCodeAt</code> it seems we get exactly the surrogate codepoints also used in UTF-16, so non-BPM characters are handled correctly.</p> <p>This problem is absolutely non-trivial. It might depend on the used JavaScript versions and engines. So if you want reliable solutions, you should have a look at:</p> <ul> <li><a href="https://github.com/koichik/node-codepoint/">https://github.com/koichik/node-codepoint/</a></li> <li><a href="http://mathiasbynens.be/notes/javascript-escapes">http://mathiasbynens.be/notes/javascript-escapes</a></li> <li>Mozilla Developer Network: charCodeAt</li> <li>BigEndian vs. LittleEndian</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POHow to convert a String to Bytearray
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UShgoebl
    1. UShgoebl
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    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. COStill not a complete answer. UTF16 is a variable-length encoding that uses 16-bit chunks to represent characters. A single character will either be encoded as 2 bytes or 4 bytes, depending on how big the charcter code value is. Since this function writes at most 2 bytes, it cannot handle all unicode character code points, and is not a complete implementation of UTF16 encoding, not by a long shot.
      singulars
      1. PO
      1. USTriynko
    2. CO@Triynko after my edit and test, do you still think this is not the complete answer? If yes, do you have an answer?
      singulars
      1. PO
      1. UShgoebl
 

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