OraFAQ Forum: Client Tools » Convert ASCII number 177 to character +/-

Home » Other » Client Tools » Convert ASCII number 177 to character +/-

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Convert ASCII number 177 to character +/- [message #671017]

Thu, 09 August 2018 13:18

richard_oak
Messages: 8
Registered: May 2016

Junior Member

Hello,

I'm trying to use the CHR function to convert ASCII extended number 177 to +/- symbol. These are my current results:

SELECT ASCII('±') FROM DUAL; -- Result = 177
SELECT CHR(177) FROM DUAL; -- Result = error

Does anyone know how to get the symbol '±'?

Richard

Report message to a moderator

[Message index]

		Convert ASCII number 177 to character +/- By: richard_oak on Thu, 09 August 2018 13:18
		Re: Convert ASCII number 177 to character +/- By: BlackSwan on Thu, 09 August 2018 13:40
		Re: Convert ASCII number 177 to character +/- By: Michel Cadot on Thu, 09 August 2018 13:42
		Re: Convert ASCII number 177 to character +/- By: richard_oak on Thu, 09 August 2018 13:52
		Re: Convert ASCII number 177 to character +/- By: Michel Cadot on Thu, 09 August 2018 14:06
		Re: Convert ASCII number 177 to character +/- By: richard_oak on Thu, 09 August 2018 14:34
		Re: Convert ASCII number 177 to character +/- By: gazzag on Fri, 10 August 2018 03:10
		Re: Convert ASCII number 177 to character +/- By: gazzag on Fri, 10 August 2018 03:12
		Re: Convert ASCII number 177 to character +/- By: richard_oak on Fri, 10 August 2018 10:25

Previous Topic:	Substitute for PL SQL Developer?
Next Topic:	Generate DDL using Sql Developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:20:25 CDT 2024