Unicode Display in PLSQL Developer

[imranrazakhan]

hi,

i have insert data in oracle like following

insert into test(name) values('\u062c\u0627\u0648\u06cc\u062f\u0020\u0645');

What i want now is that when i query from PLSQL Developer it shows me unicode in Arabic.

My PLSQL Version is 7.1.5.1398.

Second i want that when i export query result to CSV it should shows Arabic character. Currently its showing output like following

\u062c\u0627\u0648\u06cc\u062f\u0020\u0645

Regards,
imran

 

[Worker]

Oracle does not recognize the backslash as an escape character in strings. The string '\u062c' is literally a string made up of 6 characters. This is why you are getting the output you see.

An easy way to get what you're looking for on Oracle 9i and above is to use the unistr() function:
insert into test(name) values(unistr('\062c\0627\0648\06cc\062f\0020\0645'));

This function parses the string and gives you the characters you want.