Re: Currency sign ($) in SQL*Plus
Date: 1995/05/25
Message-ID: <3q277u$pa5_at_news.tamu.edu>#1/1
Philip Chee <philip_at_aleytys.pc.my> wrote:
>In article <3pvn4c$rv1_at_news.tamu.edu> m0v5533_at_tam2000.tamu.edu writes:
>SQL> select chr(157) from dual;
>C
>-
> <-------- doesn't seem to work here????
>1 row selected.
>+---------------------------------+-------------------------------------------+
>|Philip Chee: philip_at_aleytys.pc.my| This is a work of fiction.Any resemblance |
>|Tasek Cement Berhad | to persons living or dead is completely |
>|P.O.Box 254, 30908 Ipoh, MALAYSIA| coincidental. The creator of this article |
>|Voice: +605-551-011 | has asserted its moral right to be |
>| Fax: +605-566-142 | identified as the author. |
>+-------------------Eigi-Eru-Enn-Allir-Jomsvikingar-Daudir!-------------------+
Ok This is the deal. You are correct. The display of chr(157) depends on the
terminal emulation.
select chr(157) from dual will display the yen if and only if the display of
it is supported.
Try the following C program and if it doesnt work check out your termcap and
terminfo databse if you are on a UNIX machine.
main()
{
printf("%c",157);
}
If this doesnt display the yen sign and just displays the blank space, then something is wrong. If you are on a PC hold the alt key down and type 157 at the DOS prompt and you will get the yen sign. For me select chr(157) displayed the yen sign on a ansi terminal but did not on a dumb terminal emulation.
Maybe ur terminal is dumb...
Mahesh Vallampati
PH : 409 846 3794 (H) | 409 862 1070 (O) e-mail address : vallampa_at_ee.tamu.edu Received on Thu May 25 1995 - 00:00:00 CEST