Tab characters have some strange behavior when they appear in the result of a SQL query. Given the following:
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.
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.