RE: Printing extended ascii
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "dedba@xxxxxxxxxx" <dedba@xxxxxxxxxx>
- Date: Wed, 24 Mar 2010 21:45:17 -0400
Ok, but what are you NLS_LANGUAGE, NLS_TERRITORY, and NLS_CHARACTERSET on the
database server?
select * from v$nls_parameters where parameter
in('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
make sure that what you set NLS_LANG to matches the above, and then, if the
terminal is capable, it should work.
Note that NLS_LANG should be set to:
<NLS_LANGUAGE>_<NLS_TERRITORY>.<NLS_CHARACTERSET>
Hope that helps,
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of De DBA
Sent: Wednesday, March 24, 2010 9:36 PM
To: Bobak, Mark
Cc: gabriel.aragon@xxxxxx; oracle list
Subject: Re: Printing extended ascii
I tried again, just to be sure, but no. My database is 10.2.0.4 for
MAC/OSX, NLS_LANG=AMERICAN.AMERICA-WE8ISO8895P1, the terminal is capable
of displaying the plus-minus sign (perl can do it..) but SQL*Plus
stubbornly refuses.
Perhaps this differs between platforms. The OP uses SQL*Plus on SUN and
fails, I tried on MAC/OSX, fails too? My MAC/OSX terminal says it
behaves like an xterm-color. Sun's gnome-terminal should also behave
that way, I believe.
Cheers,
Tony
On 25/03/10 11:06 AM, Bobak, Mark wrote:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
