Implications of changing SQL Server collation
Can you say "leftside right"?
Why is it that Bernie Sanders always called a "socialist"?
Boss asked me to sign a resignation paper without a date on it along with my new contract
Why does this quiz question say that protons and electrons do not combine to form neutrons?
How do I avoid the "chosen hero" feeling?
Partial derivative with respect to three variables
How can I handle players killing my NPC outside of combat?
UK visa start date and Flight Depature Time
Python to write multiple dataframes and highlight rows inside an excel file
Trying to make a 3dplot
Isn't a semicolon (';') needed after a function declaration in C++?
Can a Way of Shadow Monk use Shadow Step to cling to a dark ceiling?
Is the tritone (A4 / d5) still banned in Roman Catholic music?
How to store all ctor parameters in fields
What does it mean for south of due west?
Does the double-bladed scimitar's special attack let you use your ability modifier for the damage of the attack?
What does "don't have a baby" imply or mean in this sentence?
I am a loser when it comes to jobs, what possibilities do I have?
Is there a name for this series?
What happens if both players misunderstand the game state until it's too late?
Are all power cords made equal?
What sort of grammatical construct is ‘Quod per sortem sternit fortem’?
Was the Soviet N1 really capable of sending 9.6 GB/s of telemetry?
Multiple null checks in Java 8
Implications of changing SQL Server collation
We are currently using SQL Server 2016 and currently the collation set on our database is SQL_Latin1_General_CP1_CI_AS. Our Analaysis services' collation is set to SQL_Latin1_General_CP1_CS_AS.
The recommendation from our vendor is that the relational database and the Analysis services collation should both be case sensitive.
We would like to understand if there are any downside to changing the collation on our relational database to be case sensitive as well, to match with the Analysis services.
Please help.
Thanks
sql-server sql-server-2012 collation
asked 59 secs ago
NewbieNewbie
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We are currently using SQL Server 2016 and currently the collation set on our database is SQL_Latin1_General_CP1_CI_AS. Our Analaysis services' collation is set to SQL_Latin1_General_CP1_CS_AS.
The recommendation from our vendor is that the relational database and the Analysis services collation should both be case sensitive.
We would like to understand if there are any downside to changing the collation on our relational database to be case sensitive as well, to match with the Analysis services.
Please help.
Thanks
sql-server sql-server-2012 collation
asked 59 secs ago
NewbieNewbie
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We are currently using SQL Server 2016 and currently the collation set on our database is SQL_Latin1_General_CP1_CI_AS. Our Analaysis services' collation is set to SQL_Latin1_General_CP1_CS_AS.
The recommendation from our vendor is that the relational database and the Analysis services collation should both be case sensitive.
We would like to understand if there are any downside to changing the collation on our relational database to be case sensitive as well, to match with the Analysis services.
Please help.
Thanks
sql-server sql-server-2012 collation
asked 59 secs ago
NewbieNewbie
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
We are currently using SQL Server 2016 and currently the collation set on our database is SQL_Latin1_General_CP1_CI_AS. Our Analaysis services' collation is set to SQL_Latin1_General_CP1_CS_AS.
The recommendation from our vendor is that the relational database and the Analysis services collation should both be case sensitive.
We would like to understand if there are any downside to changing the collation on our relational database to be case sensitive as well, to match with the Analysis services.
Please help.
Thanks
sql-server sql-server-2012 collation
sql-server sql-server-2012 collation
asked 59 secs ago
NewbieNewbie
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 secs ago
NewbieNewbie
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 secs ago
NewbieNewbie
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 secs ago
NewbieNewbie
1
asked 59 secs ago
NewbieNewbie
1
1
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Newbie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
Newbie is a new contributor. Be nice, and check out our Code of Conduct.
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%2f230508%2fimplications-of-changing-sql-server-collation%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
Newbie is a new contributor. Be nice, and check out our Code of Conduct.
Newbie is a new contributor. Be nice, and check out our Code of Conduct.
Newbie is a new contributor. Be nice, and check out our Code of Conduct.
Newbie is a new contributor. Be nice, and check out our Code of Conduct.
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%2f230508%2fimplications-of-changing-sql-server-collation%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
