RE: Printing extended ascii
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <gabriel.aragon@xxxxxx>, "'oracle list'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2010 14:40:29 -0400
Put the output into a file. vi the file and set list on so you can "see"
control characters as control characters, rather than the behavior displayed
by the effect on the output such as rubout and newline and backspace. If
some of them still don't show up the way you want, you can od the file.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Aragon, Gabriel (GE, Corporate, consultant)
Sent: Thursday, March 25, 2010 12:02 PM
To: oracle list
Subject: RE: Printing extended ascii
No luck, I just cant get desired character, am I doing something wrong?
sql >select parameter, value from v$nls_parameters where parameter
in('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET') ;
PARAMETER VALUE
------------------ -------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET UTF8
$ NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG
$ echo $NLS_LANG
AMERICAN_AMERICA.UTF8
sql> declare
x char(5);
begin
for i in 124..219
loop
select chr(i) into x from dual;
dbms_output.put_line(i||'-'||x);
end loop;
end;
/
2 3 4 5 6 7 8 9 10
124-|
125-}
126-~
127
128-
129-
130-
131-
132-
133-
134-
135-
136-
137-
138-
139-
140-
142-
143-
144-
145-
146-
147-
148-
149-
150-
151-
152-
153-
154-
155-
157-
159-
160-
161-¡
162-¢
163-£
164-¤
165-¥
166-¦
167-§
168-¨
169-©
170-ª
171-«
172-¬
173-
174-®
175-¯
176-°
177-±
178-²
179-³
180-´
181-µ
182-¶
183-·
184-¸
185-¹
186-º
187-»
188-¼
189-½
190-¾
191-¿
192-À
193-Á
194-
195-
196-
197-
198-
199-
200-
201-
202-
203-
204-
205-
206-
207-
208-
209-
210-
211-
212-
213-
214-
215-
216-
217-
218-
219-
-----Original Message-----
From: De DBA [mailto:dedba@xxxxxxxxxx]
Sent: Miércoles, 24 de Marzo de 2010 07:59 p.m.
To: Bobak, Mark
Cc: Aragon, Gabriel (GE, Corporate, consultant)
Subject: Re: Printing extended ascii
My bad... should've exported NLS_LANG, not just set it ... I'll go back in
my corner now and be ashamed..
Cheers,
Tony
On 25/03/10 11:45 AM, Bobak, Mark wrote:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
