Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1196
  • Last Modified:

Why I can't see a middle dash symbol while inserting chr(196) in a Table? Why I see A with umlaut?

Hello, I've noted that with the following command:

SQL> select chr(196) from DUAL;
Ä

... I obtain the A with umlaut, instead of middle dash:

How can I fix this?

I need to visualize the middle dash symbol in a graphic tool that uses Oracle DataBase.


SQL> select chr(196) from DUAL;
Ä
 
SQL>

Open in new window

0
CRISTIANO_CORRADI
Asked:
CRISTIANO_CORRADI
  • 3
  • 3
4 Solutions
 
johnsmith1962Commented:
Try chr(45) for dash.  196 is extended ascii, and Oracle doesnt use that.
0
 
kazman300Commented:
Try
select chr(45) from dual

Does this give you the correct symbol?
A list of character values are to be found at
http://www.asciitable.com/
HTH
0
 
CRISTIANO_CORRADIAuthor Commented:
I didn't know that Oracle doen't support EXTENDED ASCII.

Thank you.
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
CRISTIANO_CORRADIAuthor Commented:
chr(45) is useless because it lets a microspace between one dash and the following.

chr(196) doesn't leave microspaces between one chr(196) and the following chr(196):
0
 
johnsmith1962Commented:
What I meant was Oracle doesnt use that particular version of extended ascii.  Extended ASCII ias not standardized.  Standard ASCII is only 128 characters.

If there is a microspace, it is probably editor issue, not an Oracle issue, however you might try just running a loop from 0 to 256  and see what comes out.
0
 
johnsmith1962Commented:
Here is the code by the way:

declare
  outchar char(1);
begin
dbms_output.enable(100000);
  for loopvar in 00..256 loop
    dbms_output.put_line(to_char(loopvar)||'  '||chr(loopvar));
  end loop;
end;
0
 
CRISTIANO_CORRADIAuthor Commented:
Thank you very much for your kind help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now