Editor Fonts

[rsarwar]

If I have an ASCII character e.g. CHR(31) (Downward poiting triangle) and I copy and paste it in Plsqldev editor window, it cannot read it correctly and just shows a "?" without quotes. Is there a setting somewhere that I can set so that translation is correct or is it not supported by Plsqdev.

Plsqldev version is 5.1.6 on WinXP.

Thanks

 

[Marco Kalter]

Characters below 32 (space) are not displayed. Chr(31) is not really defined as a downward pointing arrow, though some character sets may display it as such. In your source code you should probably use the PL/SQL expression chr(31) instead of the actual character.

 

[rsarwar]

"Downward pointing arrow" was just to give a visual picture.
We don't use hard coded ascii characters in our application but instead use CHR() to represent it. We use the ascii chars extensively to concatenate long strings. And some times there is a necessity to copy and paste the raw string from our application debugger to parse/test it in Plsqldev. It's a pain to first edit it then copy/paste it since Plsqldev cannot interpret the characters less then CHR(32). Furthermore it also cannot show it correctly in the editor while debugging the code in Plsql developer.

Currently, we use combination of Sqlplus and notepad to debug it since both can show characters >= CHR(1).

I guess it will remain on my wishlist.

Thanks for your reply.