There is inconsistency in the the hex view of the data. If I just specify a chr(10) or linefeed character, the hex is incorrect.
Example:
create table temp636283 (col1 varchar2(5));
truncate table temp636283;
insert into temp636283 values ('A'); -- inserts one character
insert into temp636283 values ('B' || chr(13) || chr(10) ); -- inserts one character and a carriage return and a linefeed
insert into temp636283 values ('C' || chr(13) ); -- inserts one character and one carriage return
insert into temp636283 values ('D' || chr(10) ); -- inserts one character and one line feed
commit;
Then run:
col "DUMP" format a25
select col1, dump(col1,16) "DUMP" from temp636283;
You get:
COL1 DUMP
----- -------------------------
A Typ=1 Len=1: 41
B Typ=1 Len=3: 42,d,a
C Typ=1 Len=2: 43,d
D Typ=1 Len=2: 44,a
The dump shows a hex value for row four, "44, a". You would expect the Grid Popup Editor to show something similar, "44 0A". But instead it shows "44 0D 0A" which includes 0D, a carriage return.
How can I fix this so that it does not include the "0D" carriage return character?
Go to View | Options | Oracle | General | "Newline feed Format for character data" and change it to Unix Style.
