• 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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