Home » SQL & PL/SQL » Client Tools » Convert ASCII number 177 to character +/-
Convert ASCII number 177 to character +/- [message #671017] Thu, 09 August 2018 13:18 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Substitute for PL SQL Developer?
Next Topic: Generate DDL using Sql Developer
Goto Forum:
  


Current Time: Fri Jan 17 13:32:19 CST 2020