StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhen you store data into a VARCHAR in mysql does it take into account returns? or does it just store a block of text?
primarykey
Id
13464556
data
AcceptedAnswerId
13464570
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-11-19T23:58:49.843
FavoriteCount
0
LastActivityDate
2012-11-20T00:00:17.313
LastEditDate
LastEditorUserId
0
OwnerUserId
1837281
ParentId
0
PostTypeId
1
Score
1
ViewCount
675
LastEditorDisplayName
text
Body
<p>I'm storing text for a blog article using VARCHAR and I was wondering if it will take into account the returns in the text or just store the information as a big blob of text?</p> <p>side note: I'm not using a WYSIWYG because I don't want the blog users to be able to style their articles.</p>
Tags
<php><html><mysql>
Title
When you store data into a VARCHAR in mysql does it take into account returns? or does it just store a block of text?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAlbert Fajardo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POWhen you store data into a VARCHAR in mysql does it take into account returns? or does it just store a block of text?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COFYI: **return** = **newline** and in code that is `\n`; to answer yes it will still store the `\n`
  singulars
  PostPostId
  POWhen you store data into a VARCHAR in mysql does it take into account returns? or does it just store a block of text?
  UserUserId
  USLawrence Cherone
2. COFYI2: sometimes, returns are "\r\n". Just trying to provide complete info.
  singulars
  PostPostId
  POWhen you store data into a VARCHAR in mysql does it take into account returns? or does it just store a block of text?
  UserUserId
  USMJB

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.