Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>When you deal with network communications you must define a "protocol" to define what your "Message" is because network connections are <a href="https://stackoverflow.com/questions/3017633/difference-between-message-oriented-protocols-and-stream-oriented-protocols">Stream based not Message based</a>.</p> <p>So in the protocal is defined as the following</p> <pre> Description -> |dataIdentifier|name length|message length| name | message | Size in bytes -> | 4 | 4 | 4 |name length|message length| </pre> <p>A <code>int</code> will always be a <code>System.Int32</code> and a <code>System.Int32</code> will always take 4 bytes to store (divide 32 by 8 and you get 4).</p> <p>Here is another line showing the data types of each column, maybe that will help you</p> <pre> Description -> |dataIdentifier|name length|message length| name | message | Size in bytes -> | 4 | 4 | 4 |name length|message length| Data Type -> | int | int | int | string | string | </pre> <hr> <p>So, now why do we skip 4 bytes in the bit converter.</p> <p>Lets put the schema back up but this time I will but numbers down indicating the number of bytes</p> <p>Now the last two are "special" their length is not a fixed length like the first 3, what they do is take the value from a previous column and that is how many bytes are read in.</p> <pre> Description -> |dataIdentifier|name length|message length| name | message | Size in bytes -> | 4 | 4 | 4 | name length | message length | Bytes -> |0 1 2 3 | 4 5 6 7 | 8 9 10 11 | 12 through (12 + name length) | (12 + name length) + 1 through ((12 + name length) + 1 + message length) | </pre> <p>So you can see to read <code>dataIdentifier</code> we start at index 0 and read 4 bytes (which is how many <code>BitConverter.ToInt32</code> will read). Then when we want to read <code>nameLength</code> we need to start at index 4 then read another 4 bytes, that is why <code>BitConverter.ToInt32</code> is passed 4 (and <code>messageLength</code> will be passed 8)</p> <p>If there is anything not clear please say so in a comment and I will elaborate.</p>
    singulars
    1. This table or related slice is empty.
    1. POC# issue with packet in chat application UDP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USScott Chamberlain
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POC# issue with packet in chat application UDP
      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
    1. COThank you very much, I have understand the problem!
      singulars
      1. PO
      1. USthanh
    2. COexcuse me, please let me ask is the enum type and int type are both takes 4 bytes to store?
      singulars
      1. PO
      1. USthanh
    3. COIt all depends on how the enum was defined, by default the enum is stored as an `int`, but take a look at [the documentation](http://msdn.microsoft.com/en-us/library/sbbt4032.aspx) "*Every enumeration type has an underlying type, which can be any integral type except char. The default underlying type of enumeration elements is int. To declare an enum of another integral type, such as byte, use a colon after the identifier followed by the type...*" so if they are using the default if `int` and a `int` takes 4 bytes to store, then yes a enum takes 4 bytes (if they used an int as the backing)
      singulars
      1. PO
      1. USScott Chamberlain
 

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