Re: Printing extended ascii
Date: Thu, 25 Mar 2010 11:36:24 +1000
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.
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.
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of De DBA
> Sent: Wednesday, March 24, 2010 8:54 PM
> To: gabriel.aragon_at_ge.com
> 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.
> 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:
>> ....., '|'||rpad(fieldn,30,'X')||'|'
>> 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?
>> *Gabriel *