tab characters in SQL result grid

Worker

Member³
Tab characters have some strange behavior when they appear in the result of a SQL query. Given the following:
Code:
select 'a'||CHR(9)||'b', 'a'||CHR(9)||'b' from dual

all of the following happen:
1. The first cell shows what looks like 'a[space]b'. I understand that there is no "correct" way to display tab characters here, so that one is forgivable.
2. The second cell shows what looks like 'ab' with no trace of the tab.
3. Putting the cursor in the first cell shows odd whitespace that makes the cell value look like it really may be 'a[space]b[space][space]'.
4. Putting the cursor in the second cell suddenly makes it no longer look like 'ab' but now like 'a[space]b', and the first cell changes from 'a[space]b' to 'ab'.

It's not terribly important to me how tabs are displayed, but I would like to see at least #2 and #4 fixed.
 
I cannot immediately reproduce this. Both cells look the same and correct.

Can you let me know your PL/SQL Developer version?
 
PL/SQL Developer 9.0.6.1665, Microsoft Windows XP Pro SP2, using the font "Microsoft Sans Serif", Regular, 8pt.

It looks like this is font-related because it also happens with most other fonts including Arial and Courier New, but not with "Monaco".
 
Back
Top