Assigning value that contains special characters to variable looses special characters
So this is weird issue that is related to only one letter: ț I'm talking about Microsoft SQL Server and database that has Collation property set to Romanian_CI_AS.
When I launch this query:
select name from mytable where id = 1
I'm getting correct result containing this special character. But when I'm launching this query:
declare @name varchar(max) = (select name from mytable where id = 1)
select @name
or this one:
declare @name varchar(max) = (select name COLLATE Romanian_CI_AS from mytable where id = 1)
select @name
I'm seeing ? instead of this particular letter. Any other special characters work fine.
Do you know how can I assign this value to a variable without loosing mentioned letter?
tsql collation
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
add a comment |
So this is weird issue that is related to only one letter: ț I'm talking about Microsoft SQL Server and database that has Collation property set to Romanian_CI_AS.
When I launch this query:
select name from mytable where id = 1
I'm getting correct result containing this special character. But when I'm launching this query:
declare @name varchar(max) = (select name from mytable where id = 1)
select @name
or this one:
declare @name varchar(max) = (select name COLLATE Romanian_CI_AS from mytable where id = 1)
select @name
I'm seeing ? instead of this particular letter. Any other special characters work fine.
Do you know how can I assign this value to a variable without loosing mentioned letter?
tsql collation
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
2
use nvarchar(max) instead of varchar(max)
– Mark PM
Nov 28 '18 at 12:17
I can't believe it was so simple... Thanks a lot!
– blaballong
Nov 28 '18 at 12:18
add a comment |
So this is weird issue that is related to only one letter: ț I'm talking about Microsoft SQL Server and database that has Collation property set to Romanian_CI_AS.
When I launch this query:
select name from mytable where id = 1
I'm getting correct result containing this special character. But when I'm launching this query:
declare @name varchar(max) = (select name from mytable where id = 1)
select @name
or this one:
declare @name varchar(max) = (select name COLLATE Romanian_CI_AS from mytable where id = 1)
select @name
I'm seeing ? instead of this particular letter. Any other special characters work fine.
Do you know how can I assign this value to a variable without loosing mentioned letter?
tsql collation
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
So this is weird issue that is related to only one letter: ț I'm talking about Microsoft SQL Server and database that has Collation property set to Romanian_CI_AS.
When I launch this query:
select name from mytable where id = 1
I'm getting correct result containing this special character. But when I'm launching this query:
declare @name varchar(max) = (select name from mytable where id = 1)
select @name
or this one:
declare @name varchar(max) = (select name COLLATE Romanian_CI_AS from mytable where id = 1)
select @name
I'm seeing ? instead of this particular letter. Any other special characters work fine.
Do you know how can I assign this value to a variable without loosing mentioned letter?
tsql collation
tsql collation
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
asked Nov 28 '18 at 12:15
blaballongblaballong
9710
9710
2
use nvarchar(max) instead of varchar(max)
– Mark PM
Nov 28 '18 at 12:17
I can't believe it was so simple... Thanks a lot!
– blaballong
Nov 28 '18 at 12:18
add a comment |
2
use nvarchar(max) instead of varchar(max)
– Mark PM
Nov 28 '18 at 12:17
I can't believe it was so simple... Thanks a lot!
– blaballong
Nov 28 '18 at 12:18
2
2
use nvarchar(max) instead of varchar(max)
– Mark PM
Nov 28 '18 at 12:17
use nvarchar(max) instead of varchar(max)
– Mark PM
Nov 28 '18 at 12:17
I can't believe it was so simple... Thanks a lot!
– blaballong
Nov 28 '18 at 12:18
I can't believe it was so simple... Thanks a lot!
– blaballong
Nov 28 '18 at 12:18
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53519258%2fassigning-value-that-contains-special-characters-to-variable-looses-special-char%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53519258%2fassigning-value-that-contains-special-characters-to-variable-looses-special-char%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
2
use nvarchar(max) instead of varchar(max)
– Mark PM
Nov 28 '18 at 12:17
I can't believe it was so simple... Thanks a lot!
– blaballong
Nov 28 '18 at 12:18