Databases
StackOverflow2013
Postsdbo
POHTML::Entities encoding and single ampersand
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHTML::Entities encoding and single ampersand
    primarykey
    data
    text
    <p>I'm attempting to use the following line of perl, as described here: <a href="https://stackoverflow.com/questions/3054971/does-anyone-know-of-a-vim-plugin-or-script-to-convert-special-characters-to-their">Does anyone know of a vim plugin or script to convert special characters to their corresponding HTML entities?</a> - to encode HTML entities in Vim.</p> <pre><code>%!perl -p -i -e 'BEGIN { use HTML::Entities; use Encode; } $_=Encode::decode_utf8($_) unless Encode::is_utf8($_); $_=Encode::encode("ascii", $_, sub{HTML::Entities::encode_entities(chr shift)});' </code></pre> <p>It works fine (£ to &amp;pound, curly quotes etc.) except for an ampersand on it's own - &amp; - which is left as it is.</p> <p>I've tried removing the uf8 decoding, and looked at the CPAN documentation for HTML::Entities.</p> <p><strong>Answer:</strong></p> <p>@ZyX has answered the original question, but as others have pointed out in the comments, this is redundant as it's not actually necessary to use HTML entities if you are serving pages with a UTF-8 character set (which I am, both with the meta tag - </p> <pre><code>&lt;meta charset="utf-8"&gt; </code></pre> <p>and also in the Apache configuration:</p> <pre><code>AddDefaultCharset utf-8 </code></pre> <p>Indeed it's arguably a bad thing adding them in such cases; the filesize is bigger and the text is obfuscated should anyway want to make use of the source code.</p> <p>It's essential you ensure whatever editor(s) you use to create files are writing them in UTF-8 as well.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USWilliam Turrell
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHTML::Entities encoding and single ampersand
      1. This table or related slice is empty.
      1. VTUpMod
    1. COOut of curiosity, why you are doing this in the first place?
      singulars
      1. POHTML::Entities encoding and single ampersand
      1. USPekka 웃
    2. COI am learning Vim - frequently have to convert Word documents and other sources with smart quotes, apostrophes, currencies etc. to properly formatted HTML. Spent a while searching for Vim plugins - there didn't seem a great deal of consensus on them and I liked the Perl approach someone suggested as it (a) was quite short (b) used HTML::Entities rather than reinventing the wheel, which many people seem to have tried to..
      singulars
      1. POHTML::Entities encoding and single ampersand
      1. USWilliam Turrell
    3. COAh, fair enough. (In 90% of all cases, people use entities to work around encoding problems, in which case my standard answer is "fix the encoding problem instead", hence my question.) The problem is that in HTML, the ampersand is the escape character for entities. So every *real* ampersand needs to be escaped as `&amp;`. Not sure what the best way to fix it is in this case though, I'm not familiar with these tools
      singulars
      1. POHTML::Entities encoding and single ampersand
      1. USPekka 웃
 

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