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).
