RE: RE: display x square

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: manoj.gurnani_at_polaris.co.in
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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-----
>smitha.roney_at_mannai.com.qa
>Sent: Wednesday, August 27, 2003 4:44 PM
>To: ORACLE-L_at_fatcity.com
>
>
>
>
>
>
>Hi
>
>Make the use of Power function.
>
>Smitha Roney
>COS
>
>
>
>
>=20
>
> manoj.gurnani_at_pol
>
> aris.co.in
>
> Sent by:
>To=20
> ml-errors_at_fatcity Multiple
>recipients of list
>
> .com ORACLE-L
><ORACLE-L_at_fatcity.com>
>
>=20
>cc=20
>=20
>
> 08/27/2003 01:04
>Subject=20
> PM display x
>square
>
>=20
>
>=20
>
> Please respond to
>
> ORACLE-L_at_fatcity.
>
> 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: sfaroult_at_oriolecorp.com

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: ListGuru_at_fatcity.com (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).