Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: display x square
I am not offtopic.
Mq question was to display the notation x superscript 2 as written down in paper.
-----Original Message-----
Stephane Faroult
Sent: Wednesday, August 27, 2003 6:19 PM
To: ORACLE-L_at_fatcity.com
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).Received on Wed Aug 27 2003 - 09:14:40 CDT-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: manoj.gurnani_at_polaris.co.in 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).
- text/plain attachment: InterScan_Disclaimer.txt
![]() |
![]() |