Manoj I agree entirely with Stephane. For most of us the display is based on the ASCII character set, which doesn't have the character you desire. If you go beyond ASCII, then you are in the "device-dependent" region. For example, if you wanted to print this on an HP laser printer, then you'd need to locate the HP manual for that printer and then send the character sequence to the printer that would produce the character you wished. I think you'll have to research whatever device you will be using to produce this. Another thought is to see if HTML can define superscript characters (I'll bet it can), and produce an HTML file for better device independence.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, August 27, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I am afraid you are totally off-topic. This is not a database problem, it is a character set problem. Check the character set you are using, there may be, among those weird characters outside the 'usual' ranges, a tiny little 2 hanging up. Note down the character number, say n, and store 'x' || chr(n). I remember a colleague who 15 years back or so was storing characters which were drawing a little 'Snoopy' character on his VT220. I must add immediately that storing this is a very bad idea, for the simple reason that Oracle can perform some automatic character set translation (think of exp/imp or how you can specify the character set on a client). You are fishing for trouble. Store it as 'x ** 2' and everybody will understand. HTH SF >----- ------- Original Message ------- ----- >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 27 Aug 2003 03:39:32 > >Hi, > I do not want to display the value .=20 >Typing x superscript 2 . > >Thanks >Manoj > =20 > >-----Original Message----- >[EMAIL PROTECTED] >Sent: Wednesday, August 27, 2003 4:44 PM >To: [EMAIL PROTECTED] > > > > > > >Hi > >Make the use of Power function. > >Smitha Roney >COS > > > > >=20 > > [EMAIL PROTECTED] > > aris.co.in > > Sent by: >To=20 > [EMAIL PROTECTED] Multiple >recipients of list > > .com ORACLE-L ><[EMAIL PROTECTED]> > >=20 >cc=20 >=20 > > 08/27/2003 01:04 >Subject=20 > PM display x >square > >=20 > >=20 > > Please respond to > > [EMAIL PROTECTED] > > com > >=20 > >=20 > > > > > >Hi All, > I need to display the symbol x square i.e >x raised to 2 in >oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
