Invisible Characters in SSMS

The character 152 (˜) is invisible in the Query Editors of SSMS 2005 and SSMS 2008.  You can see it from this post.  But, if you copy the following TSQL code to the SSMS Query Editors, the character will disappear.  If you execute the query, you will be able to see it from the result.  If you measure its length, it will be 1.

select ‘˜’
select len(‘˜’)

It is a matter of how the editors handling character 152 in the Courier New font. Both Query Editors of SSMS 2005 and SSMS 2005 set the default font to Courier New font. Both do not display the character.

The text editors notepad, notepad2, and notepad++ will overlay the character to the next following character if the fonts are set to Courier New.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s