Insert special character in Oracle

[dejambo]

Good afternoon,

I have the following situation -> I want to insert the following information in the bank -> Q₇¸₁₀ but in the bank this information is inserted so -> Q7¸10 This is harming users in reports, I already changed the type of field to nvarchar, I already used the function to_nchar(string) more none of this worked.

Would anyone know a solution for this via bank? I think it can also be some sqltools configuration, because when I try to paste the information -> Q₇¸₁₀, it loses formatting, resulting in -> Q7¸10
thanks!

[madmax]

Hello Dejjo.

Dude you will have to use the ASCII table for this.

Do this test in your SQLTool

Select all

SELECT '\ '| | chr (05)  
| | chr (11)  
| | chr (12)  
| | chr (13)  
| | chr (14)  
| | chr (15)  
| | chr (16)  FROM dual; 

With this you will have to find out which ASCII and your symbol that is the way.

With this you will be able to do the insert.

I hope I have helped.

ABS ..

[dejambo]

Dear Madmax,

I am a beginner in this area .... and I think I did not quite understand what you meant ..
could you explain in another way?

Thanks.

[DanielNN]

Hi Dejambo,

The CHR () function shows the specific character according to ASCII.
You can also check which ASCII table number corresponds to a particular character:

Select all

select ascii('A'),chr(65) from dual;

But as to your ₇¸₁₀ I will check if it is possible, but with initial tests I could not .