1.0.0.15.57
Basically SQL Developer adds a horizontal tab character to the end of varchar2 columns in the results grid. I also just noticed that it adds a tab to numbers, but only if there is precision like number(7,2) and does not add it to number(4,0). In the emp table SQL Devloper does not add a tab to empno, or deptno which have no precision, but SQL Developer does add the tab to sal and comm which do have precision other than 0.
- write your favorite select statement that selects a small varchar2 from your favorite table.. Any table any varchar2.
select * from emp;
- In the results window click into any varchar2 field and Ctl+C (copy). I clicked in the ename = 'SMITH'.
- Type the following into a sql window and paste Ctl+V (paste) in between the two apostrophes. You will notice a long space after the word SMITH which is actually a horizontal tab character. Ascii 9'
select dump('SMITH ') from dual;
- You will get the following output.. Notice how SMITH is 5 characters but the dump output has 6. SQL Developer is adding a horizontal tab character to all varchar2 columns values. Notice the ascii number 9 on the end of the dump below.
Typ=96 Len=6: 83,77,73,84,72,9
When I copy and past values from queries I have to remove the tab characters. Why is SQL Developer adding a horizontal tab character? Gotta be a bug eh?
Message was edited by:
Mark Reichman