Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. POWhat is a "surrogate pair" in Java?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJeremiah Willcock
    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. VTUpMod
    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. COClarification. A string must be reversed on "true" characters (a.k.a "graphemes" or "text elements"). A single "character" code point could be one or two "char" chunks (surrogate pair), and a grapheme could be one or more of those code points (i.e. a base character code plus one or more combining character codes, each of which could be one or two 16-bit chunks or "chars" long). So a single grapheme could be three combining characters each two "chars" long, totaling 6 "chars". All 6 "chars" must be kept together, in order (i.e. not reversed), when reversing the entire string of characters.
      singulars
      1. PO
      1. USTriynko
    2. COHence the "char" data type is rather misleading. "character" is a loose term. The "char" type is really just the UTF16 chunk size and we call it character because of the relative rarity of surrogate pairs occuring (i.e. it usually represents a whole character code point), so "character" really refers to a single unicode code point, but then with the combining characters, you can have a sequence of characters that display as a single "character/grapheme/text element". This is not rocket science; the concepts are simple, but the language is confusing.
      singulars
      1. PO
      1. USTriynko
    3. COAt the time Java was being developed, Unicode was in it's infancy. Java was around for about 5 years before Unicode got surrogate pairs, so a 16-bit char fit pretty well at the time. Now, you're much better off using UTF-8 and UTF-32 than UTF-16.
      singulars
      1. PO
      1. USJonathan Baldwin
 

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