MAJOR DATA LOSS ISSUE TO FIX ASAP: code in code block treated as standard HTML

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  April 3, 2019 at 4:08 pm

  #2696452

  If you place any HTML and/or BBCodes in a code block, it will not be respected as being code. It will be handled as if not being in a code block and translated. Meaning, if I add the following to a code block (which I am escaping so that it will show correctly here):

  <a href="url">link text</a>

   

  Then it should appear exactly as you see above in the code block. It should not be translated in any way, or treated as being HTML in any way. And when I edit the post / reply, it should come back exactly as you see above. Currently the anchor tag is removed upon editing, and it didn't appear in the code block in the first place, even upon initial submit.

   

  This issue most likely relates to the following two issues:

  1. MAJOR ISSUE TO FIX ASAP: data loss for characters not included in code page 1252
  2. New blog import process mangles blog content

   

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  April 4, 2019 at 1:39 pm

  #2775054

  Two tests:

   

  First, paste in from SSMS and then add code block:

  SELECT N'<b>some HTML</b>';

   

  Second, create code block and then paste into it from SSMS:

  SELECT N'<b>some HTML</b>';

   

  Survey says?.........

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  April 4, 2019 at 1:42 pm

  #2775230

  That seemed to work when using the <b> tag. Now I will try two things that I have previously seen get translated, doing the same two tests:

   

  Paste then code block:

  SELECT N'
  anchor/link tag
  
  BBCode for link
  ';
  
  anchor/link tag
  
  BBCode for link

   

   

  Code block then paste:

  SELECT N'
  anchor/link tag
  
  BBCode for link
  ';
  
  anchor/link tag
  
  BBCode for link
  

   

  and......

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  April 4, 2019 at 1:45 pm

  #2775468

  So BBCodes and some HTML tags are translated within code blocks. The question is then: should this be the behavior, or should code blocks not translate such things? I can't remember how code blocks in the old site behaved.

   

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  April 10, 2019 at 8:01 pm

  #3098291

  Sorry for the delay. Pasting in the old site was hit/miss, depending on what you did. There were tokens to surround code, but the editor sometimes got other styles mixed in there.

  The code blocks ought to translate to text here and then wrap in a style that gets formatted on post.