StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10531362
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-05-10T09:42:45.013
FavoriteCount
0
LastActivityDate
2012-05-10T09:48:02.890
LastEditDate
2017-05-23T12:20:17.227
LastEditorUserId
-1
OwnerUserId
367456
ParentId
10529931
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
You write HTML-encoded character, so I assume you want to convert characters into <a href="http://www.w3.org/TR/html4/charset.html#h-5.3.2" rel="nofollow noreferrer">HTML EntititesRef</a>. Those were introduced in HTML 2 (<a href="http://www.w3.org/MarkUp/html-spec/html-spec_9.html#SEC9.7.2" rel="nofollow noreferrer">ISO Latin 1 Character Entity Set</a>), as well as in HTML 3.2 (<a href="http://www.w3.org/TR/REC-html32#latin1" rel="nofollow noreferrer">Character Entities for ISO Latin-1</a>) and finally some more in HTML 4 (<a href="http://www.w3.org/TR/html4/sgml/entities.html" rel="nofollow noreferrer">Character entity references in HTML 4</a>). You have not shared which of those HTML versions you're using, so I suggest you take a look at the <a href="http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references" rel="nofollow noreferrer">List of XML and HTML character entity referencesWikidpedia</a> to locate the ones you'd like to replace. The PHP function that is related to these is called: <a href="http://php.net/htmlentities" rel="nofollow noreferrer"><code>htmlentities</code>Docs</a>. Thanks to <a href="http://tools.ietf.org/html/rfc2616#section-14.17" rel="nofollow noreferrer">the content-type header in HTTP</a> and <a href="http://www.w3.org/TR/html4/charset.html#spec-char-encoding" rel="nofollow noreferrer">it's equivaltent in HTML</a>, it's not necessary to encode these characters as entities because you can just tell the browser which character set you're using. You only need to use entities in case the characters are not part of the encoding you use for the output/response. For those cases the <a href="http://php.net/htmlentities" rel="nofollow noreferrer"><code>htmlentities</code>Docs</a> or the <a href="http://php.net/strtr" rel="nofollow noreferrer"><code>strtr</code>Docs</a> functions can be used. As you have not specified which encoding are involved for the data and the target, no specific code example can by given, but only a general one: <pre><code>echo htmlentities ($string, ENT_HTML401, $encoding = 'YOUR STRING ENCODING'); </code></pre> The <a href="http://php.net/get_html_translation_table" rel="nofollow noreferrer"><code>ENT_HTML401</code> translation tableDocs</a> will convert more than the characters you might have asked for. Instead of using the build-in translation tables, you can also create your own and do the conversion with the <a href="http://php.net/strtr" rel="nofollow noreferrer"><code>strtr</code>Docs</a> function. This is also needed if the encoding of your data is not supported by <code>htmlentities</code>, for example for Adobe symbol fonts (See: <a href="https://stackoverflow.com/q/8240030/367456">How to convert Symbol font to standard utf8 HTML entity</a>). Or because you just want to run your own conversion (See <a href="https://stackoverflow.com/q/9736949/367456">How to substitute non SGML characters in String using PHP?</a>). <pre><code>/* * mappings of Windows-1252 (cp1252) 128 (0x80) - 159 (0x9F) characters: * @link http://en.wikipedia.org/wiki/Windows-1252 * @link http://www.w3.org/TR/html4/sgml/entities.html */ $cp1252HTML401Entities = array( "\x80" => '&euro;', # 128 -> euro sign, U+20AC NEW "\x82" => '&sbquo;', # 130 -> single low-9 quotation mark, U+201A NEW "\x83" => '&fnof;', # 131 -> latin small f with hook = function = florin, U+0192 ISOtech "\x84" => '&bdquo;', # 132 -> double low-9 quotation mark, U+201E NEW "\x85" => '&hellip;', # 133 -> horizontal ellipsis = three dot leader, U+2026 ISOpub "\x86" => '&dagger;', # 134 -> dagger, U+2020 ISOpub "\x87" => '&Dagger;', # 135 -> double dagger, U+2021 ISOpub "\x88" => '&circ;', # 136 -> modifier letter circumflex accent, U+02C6 ISOpub "\x89" => '&permil;', # 137 -> per mille sign, U+2030 ISOtech "\x8A" => '&Scaron;', # 138 -> latin capital letter S with caron, U+0160 ISOlat2 "\x8B" => '&lsaquo;', # 139 -> single left-pointing angle quotation mark, U+2039 ISO proposed "\x8C" => '&OElig;', # 140 -> latin capital ligature OE, U+0152 ISOlat2 "\x8E" => '&#381;', # 142 -> U+017D "\x91" => '&lsquo;', # 145 -> left single quotation mark, U+2018 ISOnum "\x92" => '&rsquo;', # 146 -> right single quotation mark, U+2019 ISOnum "\x93" => '&ldquo;', # 147 -> left double quotation mark, U+201C ISOnum "\x94" => '&rdquo;', # 148 -> right double quotation mark, U+201D ISOnum "\x95" => '&bull;', # 149 -> bullet = black small circle, U+2022 ISOpub "\x96" => '&ndash;', # 150 -> en dash, U+2013 ISOpub "\x97" => '&mdash;', # 151 -> em dash, U+2014 ISOpub "\x98" => '&tilde;', # 152 -> small tilde, U+02DC ISOdia "\x99" => '&trade;', # 153 -> trade mark sign, U+2122 ISOnum "\x9A" => '&scaron;', # 154 -> latin small letter s with caron, U+0161 ISOlat2 "\x9B" => '&rsaquo;', # 155 -> single right-pointing angle quotation mark, U+203A ISO proposed "\x9C" => '&oelig;', # 156 -> latin small ligature oe, U+0153 ISOlat2 "\x9E" => '&#382;', # 158 -> U+017E "\x9F" => '&Yuml;', # 159 -> latin capital letter Y with diaeresis, U+0178 ISOlat2 ); $outputWithEntities = strtr($output, $cp1252HTML401Entities); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIs there any function for converting french accent marks into HTML-encoded characters
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. UShakre
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.