StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14478289
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-01-23T11:11:38.937
FavoriteCount
0
LastActivityDate
2013-01-23T11:11:38.937
LastEditDate
LastEditorUserId
0
OwnerUserId
596370
ParentId
14473068
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Here you need to note down two things <ul> <li>How the characters are stored </li> <li>Endianess of the system</li> </ul> Each characters (Alphabhets, numbers or special characters) are stored as 7 bit ASCII values. While doing <code>memcpy</code> of the string(array of characters) "0006" to a 4bytes int variable, we have to give address of string as source and address of int as destination like below. <pre><code>char a[] = "0006"; int b = 0, c = 6; memcpy(&b, a, 4); </code></pre> Values of a and b are stored as below. <pre><code>a 00110110 00110000 00110000 00110000 b 00000000 00000000 00000000 00000000 c 00000000 00000000 00000000 00000110 MSB LSB </code></pre> Because ASCII value of <code>0</code> character is 48 and <code>6</code> character is 54. Now <code>memcpy</code> will try to copy whatever value present in the <code>a</code> to <code>b</code>. After <code>memcpy</code> value of b will be as below <pre><code>a 00110110 00110000 00110000 00110000 b 00110110 00110000 00110000 00110000 c 00000000 00000000 00000000 00000110 MSB LSB </code></pre> Next is endianess. Now consider we are keeping the value <code>0006</code> to the character buffer in some other way like <code>a[0] = 0; a[1] = 0; a[2]=0; a[3] = 6;</code> now if we do <code>memcpy</code>, we will the get the value as 100663296(<code>0x6000000</code>) not 6 if it is little endian machine. In big endian machine you will get the value as <code>6</code> only. <pre><code>c 00000110 00000000 00000000 00000000 b 00000110 00000000 00000000 00000000 c 00000000 00000000 00000000 00000110 MSB LSB </code></pre> So these two problems we need to consider while writing a function which converts number charters to integer value. Simple solution for these problem is to make use of existing system api <code>atoi</code>. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWrong number produced when memcpy-ing data into an integer?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USrashok
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWrong number produced when memcpy-ing data into an integer?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.