RE: Printing extended ascii
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "dedba@xxxxxxxxxx" <dedba@xxxxxxxxxx>, "gabriel.aragon@xxxxxx" <gabriel.aragon@xxxxxx>
- Date: Wed, 24 Mar 2010 21:06:44 -0400
Works for me in SQL*Plus, but you need to consider the database character set
and the value of NLS_LANG, as well as the capability of your terminal.
If I don't have NLS_LANG set, I get the upside down question mark. If I set
NLS_LANG to the database character set, then SQL*Plus doesn't attempt to do any
kind of translation, and I get the plus/minus sign, "±". Assuming your
terminal program is actually capable of displaying it, you should be able to do
the same.
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of De DBA
Sent: Wednesday, March 24, 2010 8:54 PM
To: gabriel.aragon@xxxxxx
Cc: oracle list
Subject: Re: Printing extended ascii
Hi Gabriel,
It seems to be a limitation of sql*plus. Some testing on my mac shows
that even if the terminal encoding is set to ASCII and something like:
$ perl -e 'print chr(177)'
prints the expected plus-minus sign, a
SQL> select chr(177) from dual;
still displays the unwanted question mark. However the same query
executed in tOra does return the plus-minus sign.
If that's correct you have 2 options: execute your query in a goowee
tool or use ASCII art (_-=+><) instead.
Cheers,
Tony
On 25/03/10 4:58 AM, Aragon, Gabriel (GE, Corporate, consultant) wrote:
> Hi list,
> is there any way to print extended ascii? Let's say Im trying to make a
> bar graph like:
> select
> ....., '|'||rpad(fieldn,30,'X')||'|'
> from
> ...
> to display something like:
> field1 field2 ... |XXXXXXXXXX|
> but I want to replace the X for the square character, I think is ascii
> 176, 177, 178 or 219 but cant process ascii code besides 126. Is it
> possible to do this?
> 10.2.0.4
> Sun
> UTF8
> TIA
> *Gabriel *
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
