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

Question

Post reply

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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: 736193 More actions · Answer 4

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.