Are Dynamics CRM GUIDS stored in upper-case or lower-case in the CRM Back-end?
I'm currently trying to work out if the GUID's which are CRM's Unique Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive. What I mean is this:
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
B. Would they be treated as the same record?
C. If I went to produce an extract would they all come out as lower-case or upper-case?
D. How would I even go about checking the back-end SQL Tables myself?
dynamics-crm microsoft-dynamics guid dynamics-365
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
add a comment |
I'm currently trying to work out if the GUID's which are CRM's Unique Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive. What I mean is this:
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
B. Would they be treated as the same record?
C. If I went to produce an extract would they all come out as lower-case or upper-case?
D. How would I even go about checking the back-end SQL Tables myself?
dynamics-crm microsoft-dynamics guid dynamics-365
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
add a comment |
I'm currently trying to work out if the GUID's which are CRM's Unique Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive. What I mean is this:
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
B. Would they be treated as the same record?
C. If I went to produce an extract would they all come out as lower-case or upper-case?
D. How would I even go about checking the back-end SQL Tables myself?
dynamics-crm microsoft-dynamics guid dynamics-365
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
I'm currently trying to work out if the GUID's which are CRM's Unique Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive. What I mean is this:
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
B. Would they be treated as the same record?
C. If I went to produce an extract would they all come out as lower-case or upper-case?
D. How would I even go about checking the back-end SQL Tables myself?
dynamics-crm microsoft-dynamics guid dynamics-365
dynamics-crm microsoft-dynamics guid dynamics-365
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
edited Nov 13 '18 at 12:05
James Wood
13.9k22162
13.9k22162
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
asked Nov 12 '18 at 21:48
JmcauleyJmcauley
132
132
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
I'm currently trying to work out if the GUID's which are CRM's Unique
Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive.
I'm pretty sure its uppercase, but that isn't really important.
Guid's are not strings, so the casing of the guid isn't relevant. They are 128-bit integers, which are often expressed as hexadecimal strings.
So 8a16e427-97e6-e811-a980-00224800510b and 8A16E427-97E6-E811-A980-00224800510B are equal because they represent the same hexadecimal value.
See Creating different GUID for same lowercase and upper case strings.
A better consideration is how are the guids being compared? For example if someone was to treat them as string type (rather than guid), then your values could be considered to be different (as strings).
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
No, becuase these two guids are the same. Each record has a unique guid. Casing isn't relevant.
B. Would they be treated as the same record?
These two guids refer to the same record - because they are the same guid.
C. If I went to produce an extract would they all come out as
lower-case or upper-case?
Depends how you extracted them, but again casing of the guid isn't relevant.
D. How would I even go about checking the back-end SQL Tables myself?
If you are on-premise speak to your database administrator. If you are online you would have to ask Microsoft for a copy of the database.
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
1
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
add a comment |
Guids are not stored as strings in SQL - it's a special type called uniqueidentifier.
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
add a comment |
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%2f53270602%2fare-dynamics-crm-guids-stored-in-upper-case-or-lower-case-in-the-crm-back-end%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
I'm currently trying to work out if the GUID's which are CRM's Unique
Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive.
I'm pretty sure its uppercase, but that isn't really important.
Guid's are not strings, so the casing of the guid isn't relevant. They are 128-bit integers, which are often expressed as hexadecimal strings.
So 8a16e427-97e6-e811-a980-00224800510b and 8A16E427-97E6-E811-A980-00224800510B are equal because they represent the same hexadecimal value.
See Creating different GUID for same lowercase and upper case strings.
A better consideration is how are the guids being compared? For example if someone was to treat them as string type (rather than guid), then your values could be considered to be different (as strings).
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
No, becuase these two guids are the same. Each record has a unique guid. Casing isn't relevant.
B. Would they be treated as the same record?
These two guids refer to the same record - because they are the same guid.
C. If I went to produce an extract would they all come out as
lower-case or upper-case?
Depends how you extracted them, but again casing of the guid isn't relevant.
D. How would I even go about checking the back-end SQL Tables myself?
If you are on-premise speak to your database administrator. If you are online you would have to ask Microsoft for a copy of the database.
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
1
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
add a comment |
I'm currently trying to work out if the GUID's which are CRM's Unique
Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive.
I'm pretty sure its uppercase, but that isn't really important.
Guid's are not strings, so the casing of the guid isn't relevant. They are 128-bit integers, which are often expressed as hexadecimal strings.
So 8a16e427-97e6-e811-a980-00224800510b and 8A16E427-97E6-E811-A980-00224800510B are equal because they represent the same hexadecimal value.
See Creating different GUID for same lowercase and upper case strings.
A better consideration is how are the guids being compared? For example if someone was to treat them as string type (rather than guid), then your values could be considered to be different (as strings).
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
No, becuase these two guids are the same. Each record has a unique guid. Casing isn't relevant.
B. Would they be treated as the same record?
These two guids refer to the same record - because they are the same guid.
C. If I went to produce an extract would they all come out as
lower-case or upper-case?
Depends how you extracted them, but again casing of the guid isn't relevant.
D. How would I even go about checking the back-end SQL Tables myself?
If you are on-premise speak to your database administrator. If you are online you would have to ask Microsoft for a copy of the database.
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
1
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
add a comment |
I'm currently trying to work out if the GUID's which are CRM's Unique
Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive.
I'm pretty sure its uppercase, but that isn't really important.
Guid's are not strings, so the casing of the guid isn't relevant. They are 128-bit integers, which are often expressed as hexadecimal strings.
So 8a16e427-97e6-e811-a980-00224800510b and 8A16E427-97E6-E811-A980-00224800510B are equal because they represent the same hexadecimal value.
See Creating different GUID for same lowercase and upper case strings.
A better consideration is how are the guids being compared? For example if someone was to treat them as string type (rather than guid), then your values could be considered to be different (as strings).
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
No, becuase these two guids are the same. Each record has a unique guid. Casing isn't relevant.
B. Would they be treated as the same record?
These two guids refer to the same record - because they are the same guid.
C. If I went to produce an extract would they all come out as
lower-case or upper-case?
Depends how you extracted them, but again casing of the guid isn't relevant.
D. How would I even go about checking the back-end SQL Tables myself?
If you are on-premise speak to your database administrator. If you are online you would have to ask Microsoft for a copy of the database.
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
I'm currently trying to work out if the GUID's which are CRM's Unique
Identifiers for it's back-end are Stored in uppercase or lowercase and if the GUID's are case sensitive.
I'm pretty sure its uppercase, but that isn't really important.
Guid's are not strings, so the casing of the guid isn't relevant. They are 128-bit integers, which are often expressed as hexadecimal strings.
So 8a16e427-97e6-e811-a980-00224800510b and 8A16E427-97E6-E811-A980-00224800510B are equal because they represent the same hexadecimal value.
See Creating different GUID for same lowercase and upper case strings.
A better consideration is how are the guids being compared? For example if someone was to treat them as string type (rather than guid), then your values could be considered to be different (as strings).
If a record has a GUID of 8a16e427-97e6-e811-a980-00224800510b
and another record has a GUID of 8A16E427-97E6-E811-A980-00224800510B (The same, but with upper case letters)
A. Is this scenario even possible?
No, becuase these two guids are the same. Each record has a unique guid. Casing isn't relevant.
B. Would they be treated as the same record?
These two guids refer to the same record - because they are the same guid.
C. If I went to produce an extract would they all come out as
lower-case or upper-case?
Depends how you extracted them, but again casing of the guid isn't relevant.
D. How would I even go about checking the back-end SQL Tables myself?
If you are on-premise speak to your database administrator. If you are online you would have to ask Microsoft for a copy of the database.
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
answered Nov 13 '18 at 9:53
James WoodJames Wood
13.9k22162
13.9k22162
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
1
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
add a comment |
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
1
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
Thank you so much, this is what I was looking for!
– Jmcauley
Nov 13 '18 at 17:01
1
1
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
@Jmcauley pls upvote/mark it as answer
– Arun Vinoth
Nov 22 '18 at 4:22
add a comment |
Guids are not stored as strings in SQL - it's a special type called uniqueidentifier.
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
add a comment |
Guids are not stored as strings in SQL - it's a special type called uniqueidentifier.
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
add a comment |
Guids are not stored as strings in SQL - it's a special type called uniqueidentifier.
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
Guids are not stored as strings in SQL - it's a special type called uniqueidentifier.
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
answered Nov 12 '18 at 23:50
Andrew ButenkoAndrew Butenko
4,7531912
4,7531912
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
add a comment |
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
If you're working with GUID's in C# you can use Guid.Equals() to compare GUID's.
– Aron
Nov 13 '18 at 3:40
add a comment |
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%2f53270602%2fare-dynamics-crm-guids-stored-in-upper-case-or-lower-case-in-the-crm-back-end%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
