A VARCHAR2 field contains line breaks. Double-clicking on the field in the Data Grid to open the Grid Popup Editor displays "Windows style newlines (CR/LF)" at the bottom of the Editor. Selecting all the field content (text) and copy it into a text editor the line breaks are displayed as CRLF. Using the Dataset Export function, setting it to "Delimited Text" and choosing "Clipboard" as the target, the resulting text is copied into a text editor shows the line breaks as CRLF.
Doing the exact same setting with the Dataset Export function but choosing "File" as the target instead, the field line breaks in the produced file shows as LF only. One does not know what is exactly stored in the database (whether it's CRLF or just LF - more likely just LF). But it seems weird that the Dataset Export function should produce two different results. How can one make sure the exported text file contains CRLF as does the Grid Popup Editor or the Clipboard approach? It looks like both Grid Popup Editor and Clipboard Dataset Export convert the line breaks from LF to CRLF but the File Dataset Export does not.
1. Select View | Toad Options... | Oracle | General >>> Enable the "Unix style (convert newlines to LF)" option.
2. Click "Apply" and "OK" to accept the changes.
