PL/SQL Developer HEX view shows carriage return where there is none

[GolezTrol]

PL/SQL Developer shows carriage return + line feed where there is just a line feed in the data.

Easiest way to reproduce:

select 'Hello' || chr(10) || 'world' from dual

If you inspect the results in the built-in HEX viewer in PL/SQL Developer, you can see 0D 0A, which is CR + LF.

Apparently PL/SQL Developer adjusts the line breaks to be able to show the text properly (the single line feeds would otherwise probably be ignored in Windows), but the HEX view should display the actual data rather than a corrected version.

 

[Marco Kalter]

PL/SQL Developer does indeed convert between LF and CR/LF pairs. Go to Tools > Preferences > SQL Window and disable the "Read LF as CR/LF from database" option to prevent this.

 

[AndrewN]

This setting have to be turned off by default!

I had a very unpleasant situation related to that recently. I expected data to be displayed as-is but in reality it didn't so this "feature" made me look sour.

The PL/SQL Developer is a professional tool and having such "feature" enabled by default is a bit unprofessional.

 

[Claus Pedersen]

Until this has been fixed in PLD, you can use the DUMP function to output your 'raw' ascii values from the database.

 

[azpro]

I found out that PL/SQL developer saves program window with LF line endings, while SQL window with CR/LF line endings regardless of what they were before.
This is quite annoying as in our project different files have different line endings, and I need to convert them back each time to avoid mess in git Stash.
Is it possible to save file with same line endings as they were before?