How can I view special characters in SQL Server 2012 Management Studio grid view?Odd SQL Server Studio error,...
Why don't you get burned by the wood benches in a sauna?
Exploding Numbers
Question: "Are you hungry?" Answer: "I feel like eating."
If I have Haste cast on me, does it reduce the casting time for my spells that normally take more than a turn to cast?
Was Opportunity's last message to Earth "My battery is low and it's getting dark"?
typeof generic and casted type
Is it Safe to Plug an Extension Cord Into a Power Strip?
Buying a "Used" Router
How can changes in personality/values of a person who turned into a vampire be explained?
Badly designed reimbursement form. What does that say about the company?
Cryptic cross... with words
Why do single electrical receptacles exist?
Is Screenshot Time-tracking Common?
Can I legally make a website about boycotting a certain company?
Can someone explain the need for perturbation theory in QM?
Is the tritone (A4 / d5) still banned in Roman Catholic music?
Why is quixotic not Quixotic (a proper adjective)?
Excluding or including by awk
Is it possible to detect 100% of SQLi with a simple regex?
How can I differentiate duration vs starting time
Why write a book when there's a movie in my head?
How bad is a Computer Science course that doesn't teach Design Patterns?
What did I blunder at move 23?
Is the UK legally prevented from having another referendum on Brexit?
How can I view special characters in SQL Server 2012 Management Studio grid view?
Odd SQL Server Studio error, but not on SQL Server Express?SQL Server Management Studio Express 2012 “ONLY”Is SQL Server 2012 Management Studio “Express” any different?In Job Step > Properties, only see two tabs: Package and ConfigurationHow to uninstall SQL Server Management Studio 2012?SQL Server Management Studio 2012 separated toolbarsView with a concatenated text field with line breaksSQL Management Studio 2012 not loadingSQL Management Studio - Add-on / Extension to view Column Data TypeDoes SQL Server Management Studio 2017 Contain a New Explain Feature
In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application.
The field is defined as nvarchar(MAX)
In Microsoft SQL Server Management Studio, when I go to the table and do "Edit All Rows",
on one line I see spaces in the end of the text
But when I enter my cursor in the line to edit it (not touching anything, before I even start editing), the spaces disappear (along with the trailing quote)
And when I go to New Query and execute the same query
SELECT LOGID, LogDate, SqlLog
FROM ezber_SQL_LOG
WHERE (LOGID = 1604))
I get the result without the spaces and the trailing quote:
So my guess is that there are special characters in the data (line breaks, tabs or something like that), but how can I find out for sure and know what they are?
sql-server-2012 ssms
add a comment |
In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application.
The field is defined as nvarchar(MAX)
In Microsoft SQL Server Management Studio, when I go to the table and do "Edit All Rows",
on one line I see spaces in the end of the text
But when I enter my cursor in the line to edit it (not touching anything, before I even start editing), the spaces disappear (along with the trailing quote)
And when I go to New Query and execute the same query
SELECT LOGID, LogDate, SqlLog
FROM ezber_SQL_LOG
WHERE (LOGID = 1604))
I get the result without the spaces and the trailing quote:
So my guess is that there are special characters in the data (line breaks, tabs or something like that), but how can I find out for sure and know what they are?
sql-server-2012 ssms
If you're only looking at a single row, try a query window with results to text instead of results to grid.
– Aaron Bertrand♦
Dec 19 '13 at 19:14
Results to text was giving me the same result as Results to Grid
– JF Menard
Dec 20 '13 at 15:17
add a comment |
In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application.
The field is defined as nvarchar(MAX)
In Microsoft SQL Server Management Studio, when I go to the table and do "Edit All Rows",
on one line I see spaces in the end of the text
But when I enter my cursor in the line to edit it (not touching anything, before I even start editing), the spaces disappear (along with the trailing quote)
And when I go to New Query and execute the same query
SELECT LOGID, LogDate, SqlLog
FROM ezber_SQL_LOG
WHERE (LOGID = 1604))
I get the result without the spaces and the trailing quote:
So my guess is that there are special characters in the data (line breaks, tabs or something like that), but how can I find out for sure and know what they are?
sql-server-2012 ssms
In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application.
The field is defined as nvarchar(MAX)
In Microsoft SQL Server Management Studio, when I go to the table and do "Edit All Rows",
on one line I see spaces in the end of the text
But when I enter my cursor in the line to edit it (not touching anything, before I even start editing), the spaces disappear (along with the trailing quote)
And when I go to New Query and execute the same query
SELECT LOGID, LogDate, SqlLog
FROM ezber_SQL_LOG
WHERE (LOGID = 1604))
I get the result without the spaces and the trailing quote:
So my guess is that there are special characters in the data (line breaks, tabs or something like that), but how can I find out for sure and know what they are?
sql-server-2012 ssms
sql-server-2012 ssms
edited Dec 20 '13 at 12:35
marc_s
7,09053849
7,09053849
asked Dec 19 '13 at 19:06
JF MenardJF Menard
28116
28116
If you're only looking at a single row, try a query window with results to text instead of results to grid.
– Aaron Bertrand♦
Dec 19 '13 at 19:14
Results to text was giving me the same result as Results to Grid
– JF Menard
Dec 20 '13 at 15:17
add a comment |
If you're only looking at a single row, try a query window with results to text instead of results to grid.
– Aaron Bertrand♦
Dec 19 '13 at 19:14
Results to text was giving me the same result as Results to Grid
– JF Menard
Dec 20 '13 at 15:17
If you're only looking at a single row, try a query window with results to text instead of results to grid.
– Aaron Bertrand♦
Dec 19 '13 at 19:14
If you're only looking at a single row, try a query window with results to text instead of results to grid.
– Aaron Bertrand♦
Dec 19 '13 at 19:14
Results to text was giving me the same result as Results to Grid
– JF Menard
Dec 20 '13 at 15:17
Results to text was giving me the same result as Results to Grid
– JF Menard
Dec 20 '13 at 15:17
add a comment |
2 Answers
2
active
oldest
votes
Have a look at the answer in following post: (the one with pictures).
https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms/11900246#11900246
You need "copy current cell 1:1", or you can use notepad++ as visualizer:
1
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
add a comment |
I found viewing the data as binary was the way to go for me:
SELECT @String as MyString, CAST(@String as varbinary(max)) MyString_In_Hexidecimal;
I found an ASCII table then helped decipher what was in the string.
New contributor
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f55329%2fhow-can-i-view-special-characters-in-sql-server-2012-management-studio-grid-view%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Have a look at the answer in following post: (the one with pictures).
https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms/11900246#11900246
You need "copy current cell 1:1", or you can use notepad++ as visualizer:
1
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
add a comment |
Have a look at the answer in following post: (the one with pictures).
https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms/11900246#11900246
You need "copy current cell 1:1", or you can use notepad++ as visualizer:
1
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
add a comment |
Have a look at the answer in following post: (the one with pictures).
https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms/11900246#11900246
You need "copy current cell 1:1", or you can use notepad++ as visualizer:
Have a look at the answer in following post: (the one with pictures).
https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms/11900246#11900246
You need "copy current cell 1:1", or you can use notepad++ as visualizer:
edited May 23 '17 at 12:40
Community♦
1
1
answered Dec 20 '13 at 3:17
Andrei RantsevichAndrei Rantsevich
449210
449210
1
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
add a comment |
1
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
1
1
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
I tried it and it fact I was able to find what I was looking for by using "open cell contents in external text editor (notepad++ or notepad) using "Cell visualizers" feature". Notepad++ shows "NUL" characters where the text cuts in the results grid/text
– JF Menard
Dec 20 '13 at 15:19
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
Yepp ! You can even use hex editor (or Hex plugin for notepad++) to see all data as HEX. Happy that it helped ! Read full features list and I am sure this will be not the only feature you will like ;)
– Andrei Rantsevich
Dec 20 '13 at 16:09
add a comment |
I found viewing the data as binary was the way to go for me:
SELECT @String as MyString, CAST(@String as varbinary(max)) MyString_In_Hexidecimal;
I found an ASCII table then helped decipher what was in the string.
New contributor
add a comment |
I found viewing the data as binary was the way to go for me:
SELECT @String as MyString, CAST(@String as varbinary(max)) MyString_In_Hexidecimal;
I found an ASCII table then helped decipher what was in the string.
New contributor
add a comment |
I found viewing the data as binary was the way to go for me:
SELECT @String as MyString, CAST(@String as varbinary(max)) MyString_In_Hexidecimal;
I found an ASCII table then helped decipher what was in the string.
New contributor
I found viewing the data as binary was the way to go for me:
SELECT @String as MyString, CAST(@String as varbinary(max)) MyString_In_Hexidecimal;
I found an ASCII table then helped decipher what was in the string.
New contributor
New contributor
answered 7 mins ago
SharpCSharpC
1011
1011
New contributor
New contributor
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f55329%2fhow-can-i-view-special-characters-in-sql-server-2012-management-studio-grid-view%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If you're only looking at a single row, try a query window with results to text instead of results to grid.
– Aaron Bertrand♦
Dec 19 '13 at 19:14
Results to text was giving me the same result as Results to Grid
– JF Menard
Dec 20 '13 at 15:17