Mixing
How to display symbols i.e. degree (°) same in all systems
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Our application has database Oracle 12c and Client in Java.
I wonder when using plsql developer for oracle then symbols i.e.° (degree) are displayed using system's language setting or plsql developer setting or oracle server character setting?
We have some symbols like degree which are displayed correct in some machine and some machine shows garbage character. How to do this setting to display symbols same in all systems?
I tried to store chr(176) instead of degree symbol (°) in database still no luck. It shows correct in my systems but shows null in my colleague's machine.
oracle oracle-sqldeveloper character-set
edited Jan 3 at 11:45
GMB
22k61128
asked Jan 3 at 11:16
SujitSujit
113
add a comment |
Our application has database Oracle 12c and Client in Java.
I wonder when using plsql developer for oracle then symbols i.e.° (degree) are displayed using system's language setting or plsql developer setting or oracle server character setting?
We have some symbols like degree which are displayed correct in some machine and some machine shows garbage character. How to do this setting to display symbols same in all systems?
I tried to store chr(176) instead of degree symbol (°) in database still no luck. It shows correct in my systems but shows null in my colleague's machine.
oracle oracle-sqldeveloper character-set
edited Jan 3 at 11:45
GMB
22k61128
asked Jan 3 at 11:16
SujitSujit
113
You basically need to use Unicode everywhere. In Oracle that involves usingNVARCHAR2rather thanVARCHAR2(or configuring the entire instance for Unicode). But this is really too broad and there's no magic button. You need to undesrtand how text encoding works and ensure you're doing it correctly in every step.
– Álvaro González
Jan 3 at 11:21
2
Check the session NLS settings for both you and your colleague, they must be different.
– g00dy
Jan 3 at 11:21
@g00dy, the client is in Java. However, Java does not use the client NLS Settings (at least notNLS_LANG), see Database JDBC Developer's Guide
– Wernfried Domscheit
Jan 3 at 12:23
Which tool do you use to check the data?
– Wernfried Domscheit
Jan 3 at 12:25
pl/sql developer isn't java, but oracle sql developer is java..when java just make sure your display font supports the characters involved (which will be unicode)
– thatjeffsmith
Jan 3 at 15:07
add a comment |
Our application has database Oracle 12c and Client in Java.
I wonder when using plsql developer for oracle then symbols i.e.° (degree) are displayed using system's language setting or plsql developer setting or oracle server character setting?
We have some symbols like degree which are displayed correct in some machine and some machine shows garbage character. How to do this setting to display symbols same in all systems?
I tried to store chr(176) instead of degree symbol (°) in database still no luck. It shows correct in my systems but shows null in my colleague's machine.
oracle oracle-sqldeveloper character-set
edited Jan 3 at 11:45
GMB
22k61128
asked Jan 3 at 11:16
SujitSujit
113
Our application has database Oracle 12c and Client in Java.
I wonder when using plsql developer for oracle then symbols i.e.° (degree) are displayed using system's language setting or plsql developer setting or oracle server character setting?
We have some symbols like degree which are displayed correct in some machine and some machine shows garbage character. How to do this setting to display symbols same in all systems?
I tried to store chr(176) instead of degree symbol (°) in database still no luck. It shows correct in my systems but shows null in my colleague's machine.
oracle oracle-sqldeveloper character-set
oracle oracle-sqldeveloper character-set
edited Jan 3 at 11:45
GMB
22k61128
asked Jan 3 at 11:16
SujitSujit
113
edited Jan 3 at 11:45
GMB
22k61128
asked Jan 3 at 11:16
SujitSujit
113
edited Jan 3 at 11:45
GMB
22k61128
edited Jan 3 at 11:45
GMB
22k61128
edited Jan 3 at 11:45
GMB
22k61128
22k61128
asked Jan 3 at 11:16
SujitSujit
113
asked Jan 3 at 11:16
SujitSujit
113
asked Jan 3 at 11:16
SujitSujit
113
113
You basically need to use Unicode everywhere. In Oracle that involves usingNVARCHAR2rather thanVARCHAR2(or configuring the entire instance for Unicode). But this is really too broad and there's no magic button. You need to undesrtand how text encoding works and ensure you're doing it correctly in every step.
– Álvaro González
Jan 3 at 11:21
2
Check the session NLS settings for both you and your colleague, they must be different.
– g00dy
Jan 3 at 11:21
@g00dy, the client is in Java. However, Java does not use the client NLS Settings (at least notNLS_LANG), see Database JDBC Developer's Guide
– Wernfried Domscheit
Jan 3 at 12:23
Which tool do you use to check the data?
– Wernfried Domscheit
Jan 3 at 12:25
pl/sql developer isn't java, but oracle sql developer is java..when java just make sure your display font supports the characters involved (which will be unicode)
– thatjeffsmith
Jan 3 at 15:07
add a comment |
You basically need to use Unicode everywhere. In Oracle that involves usingNVARCHAR2rather thanVARCHAR2(or configuring the entire instance for Unicode). But this is really too broad and there's no magic button. You need to undesrtand how text encoding works and ensure you're doing it correctly in every step.
– Álvaro González
Jan 3 at 11:21
2
Check the session NLS settings for both you and your colleague, they must be different.
– g00dy
Jan 3 at 11:21
@g00dy, the client is in Java. However, Java does not use the client NLS Settings (at least notNLS_LANG), see Database JDBC Developer's Guide
– Wernfried Domscheit
Jan 3 at 12:23
Which tool do you use to check the data?
– Wernfried Domscheit
Jan 3 at 12:25
pl/sql developer isn't java, but oracle sql developer is java..when java just make sure your display font supports the characters involved (which will be unicode)
– thatjeffsmith
Jan 3 at 15:07
You basically need to use Unicode everywhere. In Oracle that involves using
NVARCHAR2 rather than VARCHAR2 (or configuring the entire instance for Unicode). But this is really too broad and there's no magic button. You need to undesrtand how text encoding works and ensure you're doing it correctly in every step.– Álvaro González
Jan 3 at 11:21
You basically need to use Unicode everywhere. In Oracle that involves using
NVARCHAR2 rather than VARCHAR2 (or configuring the entire instance for Unicode). But this is really too broad and there's no magic button. You need to undesrtand how text encoding works and ensure you're doing it correctly in every step.– Álvaro González
Jan 3 at 11:21
2
2
Check the session NLS settings for both you and your colleague, they must be different.
– g00dy
Jan 3 at 11:21
Check the session NLS settings for both you and your colleague, they must be different.
– g00dy
Jan 3 at 11:21
@g00dy, the client is in Java. However, Java does not use the client NLS Settings (at least not
NLS_LANG), see Database JDBC Developer's Guide– Wernfried Domscheit
Jan 3 at 12:23
@g00dy, the client is in Java. However, Java does not use the client NLS Settings (at least not
NLS_LANG), see Database JDBC Developer's Guide– Wernfried Domscheit
Jan 3 at 12:23
Which tool do you use to check the data?
– Wernfried Domscheit
Jan 3 at 12:25
Which tool do you use to check the data?
– Wernfried Domscheit
Jan 3 at 12:25
pl/sql developer isn't java, but oracle sql developer is java..when java just make sure your display font supports the characters involved (which will be unicode)
– thatjeffsmith
Jan 3 at 15:07
pl/sql developer isn't java, but oracle sql developer is java..when java just make sure your display font supports the characters involved (which will be unicode)
– thatjeffsmith
Jan 3 at 15:07
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%2f54021242%2fhow-to-display-symbols-i-e-degree-same-in-all-systems%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%2f54021242%2fhow-to-display-symbols-i-e-degree-same-in-all-systems%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
You basically need to use Unicode everywhere. In Oracle that involves using
NVARCHAR2rather thanVARCHAR2(or configuring the entire instance for Unicode). But this is really too broad and there's no magic button. You need to undesrtand how text encoding works and ensure you're doing it correctly in every step.– Álvaro González
Jan 3 at 11:21
2
Check the session NLS settings for both you and your colleague, they must be different.
– g00dy
Jan 3 at 11:21
@g00dy, the client is in Java. However, Java does not use the client NLS Settings (at least not
NLS_LANG), see Database JDBC Developer's Guide– Wernfried Domscheit
Jan 3 at 12:23
Which tool do you use to check the data?
– Wernfried Domscheit
Jan 3 at 12:25
pl/sql developer isn't java, but oracle sql developer is java..when java just make sure your display font supports the characters involved (which will be unicode)
– thatjeffsmith
Jan 3 at 15:07