When pasting SQL into Teams, spaces get switched to NonBreaking Spaces and prevent SQL from running

Question

When you paste SQL into Microsoft Teams, the text is being changed. The spaces used for Formatting are being changed to Non-Breaking Spaces (UTF-8) and when the user you were sending receives the SQL and they paste it into their query tool, it fails due to invalid characters that the user cannot see. Only in a hex editor can you see what these characters are. If you know about the problem, you have to delete all the spaces from your query and add them back in. PITA.

We just switched to using Office 365 and this became a problem. The regular version of Teams didn't have this issue.

christovam_cursino · Answer

I also have this problem sometimes. To prevent it, I send the code using the 'code snippet' available on the format button.

zaccaromatias · Answer

Christovam_Cursino&nbsp;Since a while, even inserting it from the snippet section doesn't work for me. Copying and pasting it changes the format completely. It sounds silly, but SQL queries stop compiling and putting them back together is hard work.

scotb93 · Answer

We've been working a MS support ticket on this and it sounds like MS is going to fix this so we can paste sql into the normal teams chat.&nbsp;&nbsp;&nbsp;UsA1405&nbsp;

lostfocus · Answer

Not silly at all. It’s a pain in the butt

lostfocus · Answer

When you open the code snippet try setting the type of code to “text” I have found it works when code snippet is set to text and it fails when code snippet is set to SQL

Forum Discussion

When pasting SQL into Teams, spaces get switched to NonBreaking Spaces and prevent SQL from running

Share

Resources