tags:

views:

11

answers:

1
Q: 

SSMS 2008 converts control characters to spaces when using 'Results to Grid'

I have a table in which one column (type ntext) has data that includes carriage return and linefeeds. (CHAR(13) and CHAR(10)).

If I right click the table in SSMS 2008 and choose 'Select Top 1000 rows' and the display mode is set to "Result to Grid" it seems that control characters (like TAB and CRLF) are converted to spaces for display in the grid!!

Yet if I right click the table and choose 'Edit Top 200 rows', the control character data is shown in the resulting grid (as two small squares).

Is there any way to keep SSMS from stripping out the control characters and changing them to spaces? At first I thought that it was just a display issue but if I right click one cell and choose copy and then paste into notepad, only spaces are pasted.

I don't understand why they would do that.

A: 

When you switch to "Results to Text" or "Results to file", special characters would be preserved. In grid, they are lost, unfortunately.

It wouldn't be hard to fix it, but someone has to open bug on http://connect.microsoft.com. Then there is a chance SSMS team will react and fix it.

Since I'm no longer on that team, that's the only thing I can suggest.

TTRider  2010-09-08 21:30:43

related questions

Spaces in textfield from text-variable: php+html
Why doesn't this Regular Expression match a space?
using PHP to rename files with spaces
How do I replace tabs with spaces within variables in PHP?
Parsing XML files with Java and spaces in file path
Runtime.exec() with absolute directory
Trim leading spaces including tabs
Insert spaces instead of TAB in Emacs viper-mode
how to count space in a text statement in php
How do I include calls to methods only present in one operating system version when compiling for multiple versions?
Why is emspace or enspace breaking the CSS font line-height in the HTML?
Why would you want trailing spaces in an HTML document?
Regular Expression in C# for Last Name that includes internal space
Echo spaces in bash script
Selecting a database in mysql with spaces in its name
File and space in Python
Notepad++ tabs to spaces
Why do multiple spaces in an HTML file show up as single spaces in the browser?
Show SOME invisible/whitespace characters in Eclipse
Tab spaced data to padded columns
Tab key == 4 spaces and auto-indent after curly braces in VIM.
Tabs versus spaces in Python programming
using fstream to read every character including spaces and newline
How do you recursively unzip archives in a directory and its subdirectories from the Unix command-line?
How to setup VIM properly for editing Python files - *.py