Code Block corrupts my SQL

Question

What's up with the <Code> block feature? If I paste my SQL code into a description field, like this....

CREATE PROC [dbo].[TestMostRecent]
(
@location varchar(50),
@tsn varchar(10),
@records int = 1
)
AS
BEGIN
RETURN 0
END

And then specify that it's SQL, and click Save.

When I come back into it, and copy it to my clipboard, it comes out fine (apparently), but it must include some bad characters because it no longer parses in SQL Server Management Studio saying there are errors...

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‌'.

Jerry Chappell · Answer

This issue is my first one, since starting to pay for Jira. Does anyone have an estimate on how long it takes for Atlassian to support me?

Jerry Chappell · Answer

Here's a bit more information -- it works fine if I specify that it's SQL when I first put in the code. But if I put Java (or don't put any language), and later change it to SQL, then the text is corrupted and there's no way to ever get it back to runnable. I'm worried that I've already lost a lot of SQL scripts that I assumed were being saved... re-typing them is going to be brutal.